Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: varchar2 case insensitive
Najam,
Oracle's varchar2 columns are always case sensitive. The best way to get around this is to have another column which contains the same data as the column in question except always forced to upper case, then create the index on that column. You can use a trigger to insure that the new column's value is always the uppercase of the original column.
Hope this helps
Ken Denny
kendenny_at_bnr.ca (work)
kdenny_at_interpath.com (home)
Najam ur Rehman wrote:
>
> I am desiginig a table and I need a column of type varchar2 to be not
> case sensitive for index on that column. I have looked through the
> documentation, and I can't find out where I can specify case sensitivity
>
> to be NO. Can you please help me.
Received on Thu Sep 25 1997 - 00:00:00 CDT