Re: [GENERAL] strange encoding behavior

2006-10-24 Thread Jeff Davis
On Mon, 2006-10-23 at 10:26 +0200, Albe Laurenz wrote: > Jeff Davis wrote: > > I have a UTF8 encoded database. I can do > > > > => SELECT '\xb9'::text; > > > > But that seems to be the only way to get an invalid utf8 byte sequence > > into a text type. > [...] > > So, if I were to sum this up in

Re: [GENERAL] strange encoding behavior

2006-10-23 Thread Albe Laurenz
Jeff Davis wrote: > I have a UTF8 encoded database. I can do > > => SELECT '\xb9'::text; > > But that seems to be the only way to get an invalid utf8 byte sequence > into a text type. [...] > So, if I were to sum this up in a single question, why does cstring not > accept invalid utf8 sequences?

[GENERAL] strange encoding behavior

2006-10-20 Thread Jeff Davis
The following encoding behavior seems strange to me (v8.1.4). I have read the docs, but I am still confused. I have a UTF8 encoded database. I can do => SELECT '\xb9'::text; But that seems to be the only way to get an invalid utf8 byte sequence into a text type. Even if I do PQexecParams and se