From: "Andreas Pflug" <[EMAIL PROTECTED]> > Hiroshi Saito wrote: (snip) > >It isn't understood. > >Shouldn't put it in SQL_ASCII. > >Database comes to return the result which made a mistake. > >Or, do you use 256(2^8=256) ASCII? > > > > The DB will store 8 bit per character, regardless of the db encoding. > When it comes to conversion, only 7 bits are valid, if you tell the > backend "this is ASCII data". Your fault, if it actually isn't.
However, WHERE of SELECT will go to look for it with 7bit for ENCODING if to be SQL_ASCII. Then, it fails. And, order by, too. Therefore, it is the case which you must not use. regards, Hiroshi Saito ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html