[ADMIN] upper() with LATIN1 problem

[Lic. Guillermo González]

Hi,

The developers on my company reports me a problem with de upper() function.

The problem is:
- with a text 'magri��'
- the upper('magri��') returns MAGRI��
- NOTE that the characters '�' and '�' didn't change the case.
- the text are stored in a table in a character varying(50) field
- the database has LATIN1 encoding
- the postgresql version is 7.4.7
- the OS is Debian Linux 2.6.10

Please, can anyone help me to resolve this problem?

Thanks!
--
Guillermo Gonz�lez

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster