Re: Unicode problem ???

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.