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
