On 08/20/10 2:10 PM, Wang, Mary Y wrote:
> Hi,
> I'm having a problem right now. Some of our French users uploaded
> some files with file names that had French accent marks, and those
> file names were inserted into the Postgres database. When I examined
> the value of those file names, they all had some weird characters (the
> weird characters were in the same position where the accent marks were
> entered). I do not know how to handle this kind of situation. Most
> of my users are US based, but I have been told that there will be more
> international users in the future.
> So my questions are:
> (1) What is the best character encoding that would work for most
> of those languages that have accent marks?
> (2) I assume that I also need to do some kind of conversion in the
> front end (PHP) as well.
>
UTF8 is the answer to your questions.