convert function - Mailing list pgsql-general

From Jan Sunavec
Subject convert function
Date
Msg-id op.t270nfvzc8yns6@akela-pc.chello.sk
Whole thread Raw
Responses Re: convert function
List 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

pgsql-general by date:

Previous
From: Magicloud Wang
Date:
Subject: Would it be OK if I put db file on a ext2 filesystem?
Next
From: pilzner
Date:
Subject: Better alternative for Primary Key then serial??