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

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

[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

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