Re: String comparision in PostgreSQL

Поиск
Список
Период
Сортировка
От Nicola Cisternino
Тема Re: String comparision in PostgreSQL
Дата
Msg-id 503F4672.9040405@tiscali.it
обсуждение исходный текст
Ответ на Re: String comparision in PostgreSQL  (Craig Ringer <ringerc@ringerc.id.au>)
Ответы Re: String comparision in PostgreSQL  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
Il 30/08/2012 12.45, Craig Ringer ha scritto:
On 08/30/2012 05:16 PM, Nicola Cisternino wrote:

Thus the problem is that " .... collations are implemented using the
operating system charset and locale support ... " while, other engines,
implements collations internally ..... is it right ?

That's my understanding, but I don't know which other database systems you're talking about because you've never specifically named any.

It's entirely possible that some other DBMSs use the system locale and collation support with internal downcasing, for example.

All I know, I've already said, but I'm not an expert on Pg's innards.

--
Craig Ringer
Tahnk you for replay.
At this point, the solution could be a new, custom, operating system collation .... (something like: en_CI_US.UTF-8) ....

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

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Need help on autovacuum in postgres 9.1.2
Следующее
От: Condor
Дата:
Сообщение: Re: Strange problem with string and select