Re: Translate function and strange results ...

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

Hi Tom,

Thar's mean I need to convert my database in other enconding ?

Regards,

Le dimanche 01 novembre 2009, Tom Lane a écrit :
> 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
>

--
Hervé Piedvache

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bernard Grosperrin 2009-11-01 23:52:04 Error on compile for Windows
Previous Message Tom Lane 2009-11-01 23:00:40 Re: createlang error(s)