> 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
> 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
--
\341
What am I doing wrong? How to_ascii function should be used?
Regards
Pavel Arnošt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
