Re: unicode searches failing that use % and LIKE operators

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unicode searches failing that use % and LIKE operators
Дата
Msg-id 19842.1193077201@sss.pgh.pa.us
обсуждение исходный текст
Ответ на unicode searches failing that use % and LIKE operators  (Benjamin Weaver <benjamin.weaver@classics.ox.ac.uk>)
Ответы Re: unicode searches failing that use % and LIKE operators  (Benjamin Weaver <benjamin.weaver@classics.ox.ac.uk>)
Re: unicode searches failing that use % and LIKE operators  (Benjamin Weaver <benjamin.weaver@classics.ox.ac.uk>)
Список pgsql-general
Benjamin Weaver <benjamin.weaver@classics.ox.ac.uk> writes:
> I have the following problem:  a compound search, involving 2 wildcarded
> character search terms, in which one search term consists of Latin characters
> and the other, of UTF-8 unicode Greek characters, fails.  This is strange,
> because similar searches in which both terms are either unicode Greek or Latin
> characters succeed.

That's pretty strange all right.  What PG version is this, what database
encoding are you using, and what are the server's lc_collate and
lc_ctype settings?

            regards, tom lane

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Bitmap Heap scan 8.1/8.2
Следующее
От: Martin Marques
Дата:
Сообщение: Re: Bitmap Heap scan 8.1/8.2