Jeepers, creepers I am an idiot. All I needed to do was recompile with USE_LOCALE defined.
SELECT
'Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Å Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã' , upper('Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Å Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã'),
lower('Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Å Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã')
Returns
à à à à à à à à à à à à à à à à à à à à à à à Šà à à à à à à à à à Ã
Å Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Å Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã Ã
à à à à à à à à à à à à à à à à à à à à à à à à à à à à à à à à à à Ã
And now 'Gustaf's KnÃckebrÃd'
Comes back as 'GUSTAF'S KNÃCKEBRÃD' when capitalized
-----Original Message-----
From: Dann Corbit
Sent: Thursday, April 22, 2004 2:16 PM
To: 'pgsql-general@postgresql.org'
Subject: Has anyone come up with a work-around for the capitalization of non C-locale letters?
select productname, upper(productname) from products
gives this:
Gustaf's KnÃckebrÃd GUSTAF'S KNÃCKEBRÃD
TunnbrÃd TUNNBRÃD
GumbÃr GummibÃrchen GUMBÃR GUMMIBÃRCHEN
TourtiÃre TOURTIÃRE
PÃtà chinois PÃTà CHINOIS
Sirop d'Ãrable SIROP D'ÃRABLE
RÃd Kaviar RÃD KAVIAR
RhÃnbrÃu Klosterbier RHÃNBRÃU KLOSTERBIER
LakkalikÃÃri LAKKALIKÃÃRI
Original Frankfurter grÃne SoÃe ORIGINAL FRANKFURTER GRÃNE SOÃE
Which is failing the regression.
---------------------------(end of broadcast)---------------------------TIP 8: explain analyze is your friend
