Re: ilike and utf-8

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: ilike and utf-8
Дата
Msg-id 20060414134747.GA5676@svana.org
обсуждение исходный текст
Ответ на ilike and utf-8  ("Raphael Bauduin" <rblists@gmail.com>)
Ответы Re: ilike and utf-8  ("Tomi NA" <hefest@gmail.com>)
Re: ilike and utf-8  ("Raphael Bauduin" <rblists@gmail.com>)
Список pgsql-general
On Fri, Apr 14, 2006 at 03:16:01PM +0200, Raphael Bauduin wrote:
> Hi,
>
> Does the ilike operator work fine with cyrillic text put in a UTF-8
> encoded database?
> I've had remarks of a user (of http://myowndb.com, a web database)
> with text in cyrillic that his searches are not case insensitive,
> although I use the ilke operator in the code. And it works perfectly
> for my data (that are not in cyrillic).

UTF-8 support for case-comparison is operatnig system dependant. What
systems are we comparing here?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

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

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: export from views
Следующее
От: "Tomi NA"
Дата:
Сообщение: Re: ilike and utf-8