> 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(convert_to(c,'LATIN9'),'escape'),'LATIN9')) from
> chartest;
> ascii
> -------
> 97
> (1 row)
It gives me:
ascii
-------
225
encode
--------
e1
ascii
-------
92
So the last command have different output. Strange.
regards
Pavel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
