create custom collation from case insensitive portuguese

Поиск
Список
Период
Сортировка
От Alexandre Riveira
Тема create custom collation from case insensitive portuguese
Дата
Msg-id 4CFB6A82.1050907@objectdata.com.br
обсуждение исходный текст
Ответы Re: create custom collation from case insensitive portuguese  (Euler Taveira de Oliveira <euler@timbira.com>)
Список pgsql-hackers
Thanks to all the work they have done with this incredible database, 
postgresql.

I've achieved some success in changing collate operating system (linux) 
to generate sort of way of Brazil Portuguese hopes by adding the 
following code in LC_COLLATE

LC_COLLATE
copy "iso14651_t1_ci"
reorder-after <U00A0>
<U0020> <CAP>; <CAP>; <CAP>; <U0020>
reorder-end


And in my tests I could change the behavior of the postgresql UPPER 
changing the file i18n ... etc.

toupper /  (<U0061>, <U0041>);


So far, I understood the mechanism of change collate and reproduce in 
postgresql, and I could not generate a case-insensitive search, I 
believe that would change within the LC_COLLATE variable, but could not 
go any further than that.

Could someone guide me please.

Thanks,

Alexandre Riveira
Brazil


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: type info refactoring
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: ALTER OBJECT any_name SET SCHEMA name