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: (view raw, whole thread or download thread mbox)
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:
>>>> 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
> 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.


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-2018 The PostgreSQL Global Development Group