Re: [GENERAL] Could not Store French Accent Marks Correctly in Postgres

2010-08-21 Thread Jonathan Bond-Caron
On Fri Aug 20 05:10 PM, Wang, Mary Y wrote: > > So my questions are: > (1) What is the best character encoding that would work for most of  > those languages that have accent marks? Store data in PostgreSQL as UTF-8 > (2) I assume that I also > need to do some kind of conversion in the front end

Re: [GENERAL] Could not Store French Accent Marks Correctly in Postgres

2010-08-21 Thread Ludwig Kniprath
Am 20.08.2010 23:10, schrieb Wang, Mary Y: 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 ha

Re: [GENERAL] Could not Store French Accent Marks Correctly in Postgres

2010-08-20 Thread John R Pierce
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

[GENERAL] Could not Store French Accent Marks Correctly in Postgres

2010-08-20 Thread Wang, Mary Y
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