> 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