Hi Gord,
I understood that searches in general arecase insensitive (but I might be wrong of course). Try to use the word "BINARY" when creating the table or when making a SELECT. I am not sure how you would have to apply this to the index. Best regards Nils Valentin Tokyo/Japan 2003年 8月 26日 火曜日 09:33、gord barq さんは書きました: > I have the following index: > > 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]
