-
Does any body know how to make a UNIQUE constraint case insensitive.
For example, I create a table like:
create table test (str varchar2(10) unique);
insert into test values ('abc');
insert into test values ('Abc');
I hope that the second insert above would suffer a unique constraint violated error.
Thanks for any help.
zm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|