Skip site navigation (1) Skip section navigation (2)

Re: to_ascii function

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: (view raw, whole thread or download thread mbox)
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 ?
> 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;

 # show client_encoding;

 # SELECT '>>' || TO_ASCII('ÁÉÍÓÚáéíóú??°') || '<<';
 >>AEIOUaeiou?? <<

 The last char  in the string is dec 176 (hex 0xB0). Which  char do you
 expect after conversion to ASCII (0-127)?


 Karel Zak  <zakkr(at)zf(dot)jcu(dot)cz>

In response to


pgsql-docs by date

Next:From: Halley Pacheco de OliveiraDate: 2004-06-07 21:28:10
Subject: Re: to_ascii function
Previous:From: Halley Pacheco de OliveiraDate: 2004-06-05 13:39:15
Subject: to_ascii function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group