Andrew Hamm wrote:

> How could i forget this one?
>
> case insensitive comparisons and collating order!
>
> I don't want that applied to CHAR and VARCHAR types, since they are
> fast'n'mean byte-wise datatypes. However, since NCHAR and NVARCHAR fields
> can have a GLS locales applied, they are ideal for this little extension.
>
> I cannot find an English Locale that has case-insensitive collation. I don't
> know about other european GLS locales, but I'd wager they are case sensitive
> too, but could profit from caseless.

Can't this be achieved using functional indexes?

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+


sending to informix-list


sending to informix-list