Re: String comparision in PostgreSQL

From: Nicola Cisternino <ncister(at)tiscali(dot)it>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: String comparision in PostgreSQL
Date: 2012-08-30 10:54:42
Message-ID: 503F4672.9040405@tiscali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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) ....

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2012-08-30 11:12:22 Re: Strange problem with string and select
Previous Message Khangelani Gama 2012-08-30 10:52:17 Need help on autovacuum in postgres 9.1.2