Re: Translate function and strange results ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)com>
Cc: Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Translate function and strange results ...
Date: 2009-11-01 22:47:33
Message-ID: 2279.1257115653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-01 23:00:40 Re: createlang error(s)
Previous Message John Burski 2009-11-01 19:27:33 createlang error(s)