problem with to_ascii() function in version 8.3.3

From: Pavel Arnošt <id9848949(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with to_ascii() function in version 8.3.3
Date: 2008-06-16 17:48:29
Message-ID: 1be54ddd-3565-498e-93fc-85da648c0667@z72g2000hsb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i have a problem with to_ascii() function in version 8.3.3. I have
read Mr. Gonzales's post at
http://groups.google.com/group/pgsql.general/browse_thread/thread/f74650e3b3248ff0/9f36fb072ea1dc98?lnk=gst&q=to_ascii#9f36fb072ea1dc98
and he managed to use to_ascii function with following command
sequence:

create table chartest ( c text);
insert into chartest (c) values ('á');
select to_ascii(encode(convert_to(c,'LATIN9'),'escape'),'LATIN9') from
chartest;

His output was:

to_ascii
----------
a

but i'm getting:

to_ascii
----------
\341

What am I doing wrong? How to_ascii function should be used?

Regards
Pavel Arnošt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2008-06-16 19:20:10 Re: How to INSERT empty line into SEQUENTIAL table from PHP
Previous Message Decibel! 2008-06-16 16:14:05 Re: Clustering with minimal locking