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.
I'm running on Linux
and Postgres 8.3.8.
Any
ideas?
Thanks in
advance.
Mary
Wang
