upper() with LATIN1 problem

From: "Lic(dot) Guillermo González" <g(dot)gonzalez(at)cybira(dot)biz>
To: pgsql-admin(at)postgresql(dot)org
Subject: upper() with LATIN1 problem
Date: 2005-04-12 13:27:31
Message-ID: 425BCCC3.40403@cybira.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Zendel 2005-04-12 13:47:27 question about wal and point in time recovery
Previous Message John DeSoi 2005-04-12 12:29:34 Re: PostgreSQL replication solution?