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?= <g.gonzalez@xxxxxxxxxx> 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
