I'm getting trailing spaces in my data fields in my DBI selects on
Does anyone have a workaround or bug fix for this problem?
I'm using perl version 5.005_03 built for i386-linux
Red Hat Linux release 6.0 (Hedwig)
Kernel 2.2.5-15 on an i686
DBD - Informix.pm,v 60.6
Here's my table and data:
create table cust (
insert into cust values ("A15","John Doe")
Here's my perl code:
$sql_stmt = "select cust_num, cust_name from cust where cust_num =
my $cursor = ($dbh)->prepare($sql_stmt) || die $dbh->errstr;
$cursor->execute || die $dbh->errstr;
[John Doe ]
I don't want the trailing spaces. Even when no data is returned from
a particular column, I get spaces in my fields.