MySQL ucfirst doesn't work.

sirtopdog

New Member
I have this table:\[code\]CREATE TABLE IF NOT EXISTS `events` ( `evt_id` int(11) NOT NULL AUTO_INCREMENT, `evt_name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT 'ucfirst', `evt_description` varchar(100) DEFAULT NULL, `evt_startdate` date NOT NULL, `evt_enddate` date DEFAULT NULL, `evt_starttime` time DEFAULT NULL, `evt_endtime` time DEFAULT NULL, `evt_amtpersons` int(11) DEFAULT NULL, `sts_id` int(11) NOT NULL, `adr_id` int(11) DEFAULT NULL, `evt_amtPersonsSubs` tinyint(4) NOT NULL DEFAULT '0', `evt_photo` varchar(50) DEFAULT NULL, `sys-mut-dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `sys-mut-user` varchar(20) DEFAULT NULL, `sys-mut-id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`evt_id`), KEY `sts_id` (`sts_id`), KEY `adr_id` (`adr_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;\[/code\]But when I add in data into \[code\]evt_name\[/code\] my first character is not capitalized. Any ideas?Further information:MySQL client version: 5.1.37I want to do this in the database so that I don't have to do \[code\]ucfirst\[/code\] with php always.
 
Top