Postgres Pro
Downloads
Home   >   mailing lists

Re: Translate function and strange results ... - Mailing list pgsql-general

From Tom Lane
Subject Re: Translate function and strange results ...
Date
Msg-id 2279.1257115653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Translate function and strange results ...  (Arjen Nienhuis <a.g.nienhuis@gmail.com>)
Responses Re: Translate function and strange results ...  (Hervé Piedvache <bill.footcow@gmail.com>)
List pgsql-general
Tree view 
Arjen Nienhuis <a.g.nienhuis@gmail.com> writes:
> I don't know why it does that though. Maybe it's the server_encoding. What
> does SHOW server_encoding; tell you?

He said SQL_ASCII.  translate() will definitely not work nicely with
multibyte characters if it doesn't know they are multibyte :-(

            regards, tom lane

pgsql-general by date:

Previous
From: John Burski
Date:
Subject: createlang error(s)
Next
From: Tom Lane
Date:
Subject: Re: createlang error(s)