Re: Unicode problem ???

In article <200404211522.39036.peter_e@gmx.net>,
Peter Eisentraut <peter_e@gmx.net> writes:

> Am Mittwoch, 21. April 2004 14:37 schrieb Priem, Alexander:
>> I have a PostgreSQL 7.4 database running, which was initdb-ed using
>> standard (SQL_ASCII) encoding, with -lc-collate=C option set.
>>
>> Everything is running fine, but I just discovered something funny. If text
>> containing characters like ë is inserted into the database (text field),
>> the inserting goes fine. When I view this data using phpPgAdmin (v3.2.1) it
>> looks fine, including these special characters.

> You can try to update pg_database to change the database encoding to LATIN1.
> SQL_ASCII is only totally supported for, well, ASCII characters.

Or even better to LATIN9.  This also includes the Euro symbol and the
French OE ligature forgotten in LATIN1.