-
Folks!
On my Oracle instances, string "aaa" does not equal "AAA". In other words, if I have a table MyTable with a unique index on MyTable's single char(3) field. The commands:
insert into MyTable values ('aaa');
insert into MyTable values ('AAA');
work fine. How do I make the instance case sensitive, so that the second insert above would error with a unique key violation?
Thanks in advance!
Joe B.
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
|