Dear Karel,
The server encoding and the client encoding are
LATIN1. These results are from phpPgAdmin:
This is ok:
select ascii('ª')
ascii
-
170
select chr(170)
chr
---
ª
select to_ascii(chr(170))
to_ascii
a
But this is not ok!
select ascii('º')
ascii
-
186
select chr(1
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 encodi
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)
Regards,
Halley
___
