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
<accent sensitive> := ACCENT SENSITIVE | ACCENT INSENSITIVE
You can specify for each collation if it is case sensitive or not and collation
function should be responsible to correctly handle this flag.
In response to
pgsql-hackers by date
|Next:||From: David E. Wheeler||Date: 2008-06-03 19:18:48|
|Subject: Re: Case-Insensitve Text Comparison|
|Previous:||From: Teodor Sigaev||Date: 2008-06-03 18:53:06|
|Subject: Re: [GENERAL] Fragments in tsearch2 headline|