problem with to_ascii() function in version 8.3.3

Поиск
Список
Период
Сортировка
Искать
От
Pavel Arnošt
Тема
problem with to_ascii() function in version 8.3.3
Дата
Msg-id
1be54ddd-3565-498e-93fc-85da648c0667@z72g2000hsb.googlegroups.com
Список
Дерево обсуждения
Re: problem with to_ascii() function in version 8.3.3 Pavel Arnošt <id9848949@gmail.com>
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
В списке pgsql-general по дате отправления
От: Oscar Uribe
Дата:
Сообщение: Sequences
От: Cyril SCETBON
Дата:
FAQ