> Could you run the following queries and compare with my results:
>
> test=> select ascii(c) from chartest;
> ascii
> ---
> 225
> (1 row)
>
> test=> select encode(convert_to(c,'LATIN9'),'hex') from chartest;
> encode
>
> e1
> (1 row)
>
> test=> select
> ascii(to_ascii(encode(co
Pavel Arnošt wrote:
>>> insert into chartest (c) values ('á');
>>> select to_ascii(encode(convert_to(c,'LATIN9'),'escape'),'LATIN9') from
>>> chartest;
>>> to_ascii
>>> --
>>> \341
>>
>> What answer do you get to the following two SQL statements:
>>
>> SHOW server_encoding;
>> SHOW clien
> What answer do you get to the following two SQL statements:
>
> SHOW server_encoding;
> SHOW client_encoding;
>
> Maybe that will help to understand.
Hi,
both commands shows "UTF8". Changing client encoding with "\encoding
LATIN9" does not have any effect on to_ascii command (I don't know if
it
Pavel Arnošt wrote:
> 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
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
