MySQL Forums
Forum List  »  General

set column type - case sensitive
Posted by: hector vass
Date: January 12, 2005 11:34AM

I am a big fan of the set column type - but does anyone know how to make it case sensitive. For examplie I need it to distinquish between lower case a and upper case A

create table t
(
mycharcol char(1),
mysetcol set("a","A","b","B","c","C")
);
insert into t
(mycharcol,mysetcol)
values
("a","a"),
("b","b"),
("c","c"),
("A","A"),
("B","B"),
("C","C");
select
*
from t;

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
set column type - case sensitive
January 12, 2005 11:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.