Re: Unicode problem ??? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Unicode problem ???
Date
Msg-id 200404211522.39036.peter_e@gmx.net
Whole thread Raw
In response to Unicode problem ???  ("Priem, Alexander" <ap@cict.nl>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Stijn Vanroye"
Date:
Subject: Re: Unicode problem ???
Next
From: "Priem, Alexander"
Date:
Subject: Re: Unicode problem ???