From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: to_ascii function |
Date: | 2004-06-07 09:16:08 |
Message-ID: | 20040607091608.GE28529@zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Sat, Jun 05, 2004 at 10:39:15AM -0300, Halley Pacheco de Oliveira wrote:
> This query didn't work as I was expecting. Any reasons
> for that ?
>
> SELECT TO_ASCII('ÁÉÍÓÚáéíóú??°')
>
> result -> 'AEIOUaeioua '
>
> I used psql, java and phpPgAdmin without success.
>
> (PostgreSQL 7.4.2 encoding latin1)
Are all chars in your query LATIN1 symbols and are you sure that all
used chars have counterpart in ASCII? For this to_ascii() support
LATIN1, LATIN2 and WIN1250 only. I'm not sure if there is a way how
convert others special chars (for example some Asiatic encodings).
# show server_encoding;
server_encoding
-----------------
LATIN1
# show client_encoding;
client_encoding
-----------------
LATIN1
# SELECT '>>' || TO_ASCII('ÁÉÍÓÚáéíóú??°') || '<<';
?column?
-------------------
>>AEIOUaeiou?? <<
The last char in the string is dec 176 (hex 0xB0). Which char do you
expect after conversion to ASCII (0-127)?
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
From | Date | Subject | |
---|---|---|---|
Next Message | Halley Pacheco de Oliveira | 2004-06-07 21:28:10 | Re: to_ascii function |
Previous Message | Halley Pacheco de Oliveira | 2004-06-05 13:39:15 | to_ascii function |