Hi,
I look at the variable/parameter LC_CTYPE and it is set to C (I think this is the default) for performance reason, the installer says.
If I use LATIN1 (spanish) what value is the best option for this variable/parameter?
Thanks!
-- Guillermo Gonz�lez
Tom Lane wrote:
=?ISO-8859-1?Q?=22Lic=2E_Guillermo_Gonz=E1lez=22?= <[EMAIL PROTECTED]> writes:
The problem is: - with a text 'magri��' - the upper('magri��') returns MAGRI�� - NOTE that the characters '�' and '�' didn't change the case.
This is determined by your locale (specifically LC_CTYPE) not by what the database thinks the encoding is. You'll probably want to re-initdb in the desired locale.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
