Re: Unicode problem ???

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Priem, Alexander" <ap(at)cict(dot)nl>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unicode problem ???
Date: 2004-04-21 13:22:39
Message-ID: 200404211522.39036.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Priem, Alexander 2004-04-21 13:41:37 Re: Unicode problem ???
Previous Message Stijn Vanroye 2004-04-21 13:15:26 Re: Unicode problem ???