Re: Case-Insensitve Text Comparison

On Jun 3, 2008, at 12:06, Zdenek Kotala wrote:

> 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.

Wooo! Now if only i could apply that on a per-column basis. Still,
it'll be great to have this for a whole database.

Thanks, looking forward to it.

David