Search Postgresql Archives

Re: problem with to_ascii() function in version 8.3.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux