"Aviad Harell" <[EMAIL PROTECTED]> wrote:
> tnx for the quick replay.
>
> > when using collate NOCASE on some column definition, how does a
> > specific element is chose to be returned, the upper case, the lower
> > case or the first one appears?
>
> >Collation doesn't affect how the data is stored, just how it's compared.
> >You will get your strings out in exactly the same form you put them in.
>
> lets say i have the following table:
>
> create table t1 (col1 text collate nocase)
>
> insert t1 values {a}
> insert t1 values {A}
>
> and then i execute the following:
>
> select col1
> from t1
> group by col1
>
>
> the result will be: a or A?
>
That is undefined. It might be either.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
