can not make column with varchar as binary
Posted by:
ashok kumar
Date: September 23, 2005 02:57AM
Hi Friends,
I created (as below.....),I am not able to make the 'user_id' binary.any help please
CREATE TABLE `user` (
`user_id` varchar(10) NOT NULL,
`cust_id` int(10) unsigned NOT NULL default '0',
`role_id` int(10) unsigned NOT NULL default '0',
`user_pwd` longtext character set utf8 collate utf8_bin NOT NULL,
`user_f_name` varchar(45) default NULL,
`user_l_name` varchar(45) default NULL,
`user_desig` varchar(45) default NULL,
`user_sex` char(1) default NULL,
`user_phone` varchar(45) default NULL,
`user_fax` varchar(45) default NULL,
`user_email` varchar(45) default NULL,
`status` varchar(15) default NULL,
PRIMARY KEY (`user_id`),
KEY `FK_user_1` (`cust_id`),
KEY `FK_user_2` (`role_id`),
CONSTRAINT `FK_user_2` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`),
CONSTRAINT `FK_user_1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`cust_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 10240 kB; InnoDB free: 10240 kB; (`cust_id`) RE';