SQL_ASCII - Mailing list pgsql-general

From Dennis Björklund
Subject SQL_ASCII
Date
Msg-id Pine.LNX.4.44.0306090820060.17926-100000@zigo.dhs.org
Whole thread Raw
List pgsql-general
What is the character encoding SQL_ASCII? I managed to store 8-bit latin1
characters in such a database by mistake and got errors when I tried to
get it out with a client encoding set to utf-8. I got strings out that was
not valid utf-8 strings.

From that I draw the conclusion that it's not restricted to old fashion
7-bit bit ascii.

My guess now is that it allows you to put in 8-bit values but that these
characters are unknown and just returned no matter what client encoding?
And when the client encoding is utf-8 it produces invalid strings.

--
/Dennis


pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Strange result with select/not null/OR
Next
From: Arguile
Date:
Subject: Re: update phenomenom