Fulko Hew wrote: > I am using mySQL 3.22.4a-beta > yes, I know its old :-( > > I have just stumbled across a problem with how it > treats 'uniqueness' in table contents. > > I have a table with a column defined as: > > create table test (name varchar(80) not null); > alter table test ADD UNIQUE (name), ADD INDEX (name);
If you want this to be case sensitive you need to add "BINARY" to any '*char' columns: create table test (name varchar(80) BINARY not null); alter table test ADD UNIQUE (name), ADD INDEX (name); b. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php