Re: Collate

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 01 Feb 2003 20:45:55 GMT
Message-ID: <BA6171FE.876B%markbtownsend@attbi.com>

in article zUV_9.114492$Ui4.3251856_at_news1.telusplanet.net, Jasminder Rai at jasrai_at_canada.com wrote on 2/1/03 12:14 PM:

> Thanks. I will probably use that as a work around. What I am wondering is
> that when I create a table in SQL server 2000 I use 'COLLATE
> SQL_Latin1_General_CP1_CI_AI' as column definition, which allows me to use
> the quer

At this stage there is no NLS_SORT parameters that help with case insensitivity.

Use a view in Oracle to hide the UPPER function and Bob's your mothers brother. Received on Sat Feb 01 2003 - 14:45:55 CST