Posted on 2008-10-01 19:34:04-07 by fmr
Null terminated CHARs in results
Hi,

DBD::ODBC version 1.17
DBI version 1.40
OS: RHEL4
Perl: 5.8
DBMS and ODBC driver: Sybase IQ 12.7
The problem is that all CHARs and DATEs in fetchrow_array results have \0 at the end, overwriting the last character of the column. eg a column which should have 'abc' has ab\0 instead.

DBI->trace(4) shows the type for all these columns is unknown (0).

Does anyone have any ideas?

Thanks in advance
Regards
Direct Responses: 8910 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.