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.