Re: UTF-8 and LIKE vs =

Поиск
Список
Период
Сортировка
От David Wheeler
Тема Re: UTF-8 and LIKE vs =
Дата
Msg-id 0F9BE143-F77E-11D8-BD80-000393D9369E@kineticode.com
обсуждение исходный текст
Ответ на Re: UTF-8 and LIKE vs =  (Joel <rees@ddcom.co.jp>)
Список pgsql-general
On Aug 24, 2004, at 6:58 PM, Joel wrote:

> Sorry, I guess I wasn't clear. It's almost directly corollary to
> ignoring case. (Almost, but not quite.) Kind of like querying with
> "TEST"
> and getting records with "test".

How interesting!

> Which means that the correct solution now is beyond the question of
> what
> did the vendor think you would want. No way the vendor is going to be
> willing to think you really want that, in spite of the number of people
> who want precisely that. We don't yet have a mechanism that works for
> general multiple language solutions.

Right, except for "no locale" (is C locale the same thing?).

> At this point in time, "no locale" is probably close to best practice,
> but it leaves you a lot of work.

It does?

Regards,

David


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: R: space taken by a row & compressed data
Следующее
От: David Wheeler
Дата:
Сообщение: Re: UTF-8 and LIKE vs =