Strings get converted to lower case on insert
We have a strange issue when inserting data into a table. Here is the table DDL:
CREATE TABLE `command` (
`code` char(1) NOT NULL,
`name` varchar(50) default NULL,
`sitecode` varchar(50) default NULL,
`host` varchar(50) NOT NULL,
`port` varchar(20) NOT NULL default 'ANY',
`pid` varchar(20) NOT NULL default 'ANY',
`command` varchar(255) default NULL,
`issued` datetime NOT NULL,
`delivered` tinyint(4) NOT NULL default '0',
KEY `code` (`code`),
KEY `command_cmb1` (`sitecode`,`host`,`delivered`),
KEY `command_cmb2` (`name`,`host`,`port`,`pid`),
CONSTRAINT `command_ibfk_1` FOREIGN KEY (`code`) REFERENCES `process_code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
We are running Perl 5.8.8, DBI 1.604, DBD::mysql 4.007, mysql 5.0.22 on RHEL 5.1. The insert statements are executed in Perl code, and we know for sure what values we pass on to them. The issue only affects the 'name' column when we insert an 'ABS' string there, which gets converted into 'abs' in the table. The most bizarre thing is that everything works fine on the other, identical server. Has anybody experienced something like that, and what could be done to fix that?
Thanks in advance.