convert function

From: "Jan Sunavec" <jan(dot)sunavec(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: convert function
Date: 2007-12-12 11:53:29
Message-ID: op.t270nfvzc8yns6@akela-pc.chello.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I have problem with "convert" function. Previous behaviour was
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
=======================================
jan

In postgresql 8.3 is quite new behaviour.
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
======================================
"j\241n"

This, drives me crazy. I mean, this is not useable for non english
country. I don't need convert to \241 characters. I understand that
someone need this behavour. But there should be possibility switch to
"normal" behaviour.

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-12-12 11:56:35 Re: very slow query
Previous Message Alban Hertroys 2007-12-12 11:53:28 Re: Trigger - will not perform INSERT