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

Re: Case-Insensitve Text Comparison

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: "David E(dot) Wheeler" <david(at)kineticode(dot)com>, pgsql-hackers(at)postgresql(dot)org, Radek Strnad <radek(dot)strnad(at)gmail(dot)com>
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-03 20:18:32
Message-ID: 4845A718.9010008@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Pavel Stehule napsal(a):
> 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?
> 
It seems to me, that CREATE COLLATION command supports only firebird other 
databases like MySQL, MS SQL have hardcoded list of collations.

		Zdenek



In response to

pgsql-hackers by date

Next:From: Decibel!Date: 2008-06-03 20:43:14
Subject: Re: BUG #4204: COPY to table with FK has memory leak
Previous:From: Pavel StehuleDate: 2008-06-03 19:45:12
Subject: Re: Case-Insensitve Text Comparison

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