Re: varchar2 case insensitive

Define a check constraint on the column to convert it to uppercase using UPPER(). There is an example of this in "SQL Language Reference Manual", Commands, CONSTRAINT clause (p. 4-133 in my text). For example:
  create table blick
    (col_nocase VARCHAR2

       CONSTRAINT ck_col_nocase_to_upper
         CHECK (col_nocase = UPPER(col_nocase)),
     ...

Note I've given the check constraint given a meaningful name (ck_col_nocase_to_upper), rather than letting the system generate one (as SYS_Cxxxx). You can also define the check constraint later using alter table.
- Dan Clamage dclamage_at_idcomm.com

Najam ur Rehman <najam_at_mini-systems.com> wrote in article <3428C239.65BD49C9_at_mini-systems.com>...
> 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 CEST