CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so, how can I have it so that it is indeed case sensitive because I'm importing lots of data from Oracle which is case sensitive.
Thanks.
_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
