| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Could not Store French Accent Marks Correctly in Postgres |
| Date: | 2010-08-20 21:44:36 |
| Message-ID: | 4C6EF744.3080602@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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.
>
UTF8 is the answer to your questions.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2010-08-21 09:08:07 | Re: searchable book database |
| Previous Message | Wang, Mary Y | 2010-08-20 21:10:37 | Could not Store French Accent Marks Correctly in Postgres |