Could not Store French Accent Marks Correctly in Postgres
| От | Wang, Mary Y |
|---|---|
| Тема | Could not Store French Accent Marks Correctly in Postgres |
| Дата | |
| Msg-id | FA20D4C4FEBFD148B1C0CB09913825FC0458C8A036@XCH-SW-06V.sw.nos.boeing.com обсуждение исходный текст |
| Ответы |
Re: Could not Store French Accent Marks Correctly in Postgres
Re: Could not Store French Accent Marks Correctly in Postgres Re: Could not Store French Accent Marks Correctly in Postgres |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: