Re: Case-Insensitve Text Comparison

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Case-Insensitve Text Comparison
Дата
Msg-id 19957.1212424410@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Case-Insensitve Text Comparison  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: Case-Insensitve Text Comparison
Список pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> On Jun 1, 2008, at 21:08, Tom Lane wrote:
>> [ broken record... ]  Kinda depends on your locale.  However,  
>> tolower()
>> is 100% guaranteed not to work for multibyte encodings, so citext is
>> quite useless if you're using UTF8.  This is fixable, no doubt, but
>> it's not fixed in the project as it stands.

> Would the use of str_tolower() in formatting.c fix that?

Yeah, you need something equivalent to that.  I think that whole area
is due for refactoring, though --- we've got kind of a weird collection
of upper/lower/initcap APIs spread through a couple of different files.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Overhauling GUCS
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Core team statement on replication in PostgreSQL