Re: Character Encoding Confusion

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Character Encoding Confusion
Date: 2004-03-09 10:19:09
Message-ID: 200403091119.09441.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Markus Wollny wrote:
> As ODBC seems to be blissfully unaware of any character encodings
> whatsoever, so were we - our databases are encoded in SQL_ASCII,
> although we have stored german special chars (ÄÖÜäöü and ß), and from
> what I have read so far, these are stored as multibyte and thus
> exceed the SQL-ASCII specification.

SQL_ASCII is not a real encoding, it simply means to pass bytes through
without looking at them. If you want to get sensible behavior with
German characters, you should use LATIN9 as the server encoding.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Robert Norris 2004-03-09 10:19:28 Re: Question on Opteron performance
Previous Message Nick Barr 2004-03-09 10:01:32 Re: Question on Opteron performance