lower/upper on latin2 encoding

From: Laukó Péter <plauko(at)freemail(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: lower/upper on latin2 encoding
Date: 2002-08-22 01:02:00
Message-ID: freemail.20020722030200.79485@fm7.freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi list,
can anyone tell me why the characters with accents are not changed by lower and upper? Is it a bug, or should I configure anything else than the db encoding???
thanks in advance, Peter

tpa=# select getdatabaseencoding();
getdatabaseencoding
---------------------
LATIN2
(1 row)

tpa=# select upper('árvíztűrő tükörfúrógép aeiou');
upper
------------------------------
áRVíZTűRő TüKöRFúRóGéP AEIOU
(1 row)

tpa=# select lower('ÁRVÍZTŰRŐ TÜKÖRFÚRÓGÉP AEIOU');
lower
------------------------------
ÁrvÍztŰrŐ tÜkÖrfÚrÓgÉp aeiou
(1 row)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-08-22 01:15:33 Re: lower/upper on latin2 encoding
Previous Message Ray Hunter 2002-08-22 00:43:07 Primary Keys