Could not Store French Accent Marks Correctly in Postgres

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Could not Store French Accent Marks Correctly in Postgres
Date: 2010-08-20 21:10:37
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC0458C8A036@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-08-20 21:44:36 Re: Could not Store French Accent Marks Correctly in Postgres
Previous Message Miguel Vaz 2010-08-20 17:55:47 Re: searchable book database