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!