Re: upper() with LATIN1 problem

Поиск
Список
Период
Сортировка
От Lic. Guillermo González
Тема Re: upper() with LATIN1 problem
Дата
Msg-id 425D3865.7090406@cybira.biz
обсуждение исходный текст
Ответ на Re: upper() with LATIN1 problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: upper() with LATIN1 problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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@cybira.biz> 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
>



В списке pgsql-admin по дате отправления:

Предыдущее
От: lst_hoe01@kwsoft.de
Дата:
Сообщение: Re: question about wal and point in time recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: upper() with LATIN1 problem