Skip site navigation (1) Skip section navigation (2)

Re: Case-Insensitve Text Comparison

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>
Cc: "David E(dot) Wheeler" <david(at)kineticode(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-03 19:45:12
Message-ID: 162867790806031245p56258e24t81fa23e6d1a49266@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2008/6/3 Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>:
> David E. Wheeler napsal(a):
>>
>> On Jun 3, 2008, at 02:27, Zdenek Kotala wrote:
>>
>>> The proposal of GSoc is there:
>>> http://archives.postgresql.org/pgsql-hackers/2008-05/msg00857.php
>>>
>>> It should create basic framework for full SQL COLLATION support. All
>>> comments are welcome.
>>
>> That looks great, Zdenek. I'm very excited to have improved SQL COLLATION
>> support in core. But if I could ask a dumb question, how would I specify a
>> case-insensitive collation? Or maybe the Unicode Collation Algorithm is
>> case-insensitive or has case-insensitive support?
>
> It is simple. SQL standard does not specify notation for that (chapter
> 11.34). But there is proposed notation:
>
> CREATE COLLATION <collation name> FOR <character set specification> FROM
> <existing collation name> [ <pad characteristic> ] [ <case sensitive> ] [
> <accent sensitive> ] [ LC_COLLATE <lc_collate> ] [ LC_CTYPE <lc_ctype> ]
>
> <pad characteristic> := NO PAD | PAD SPACE
> <case sensitive> := CASE SENSITIVE | CASE INSENSITIVE
> <accent sensitive> := ACCENT SENSITIVE | ACCENT INSENSITIVE
>

it is in conformance with others databases? Or what is syntax used in others db?

regards
Pavel

>
> You can specify for each collation if it is case sensitive or not and
> collation function should be responsible to correctly handle this flag.
>
>
>                Zdenek
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Responses

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2008-06-03 20:18:32
Subject: Re: Case-Insensitve Text Comparison
Previous:From: Zdenek KotalaDate: 2008-06-03 19:26:06
Subject: Re: Case-Insensitve Text Comparison

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group