MySQL Forums
Forum List  »  Perl

Strings get converted to lower case on insert
Posted by: Alexander Saip
Date: May 23, 2008 10:47AM

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`)

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.

Options: ReplyQuote

Written By
Strings get converted to lower case on insert
May 23, 2008 10:47AM

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.