Re: problem with to_ascii() function in version 8.3.3 - Mailing list pgsql-general

From Pavel Arnošt
Subject Re: problem with to_ascii() function in version 8.3.3
Date
Msg-id 984a479c-0194-4624-b8cc-50b51d9d290b@8g2000hse.googlegroups.com
Whole thread Raw
In response to problem with to_ascii() function in version 8.3.3  (Pavel Arnošt <id9848949@gmail.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: "coliban@gmail.com"
Date:
Subject: postgres generates too much processes per minute
Next
From: Cyril SCETBON
Date:
Subject: Re: Error when trying to drop a tablespace