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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
