Posted on 2008-10-02 07:22:18-07 by mjevans in response to 8906
Re: Null terminated CHARs in results
Does make test for DBD::ODBC complete successfully? Could you produce the smallest script you can to demonstrate the problem e.g., a simple select on the a char and date column followed by a fetch. Then append to the top of the script:
use DBD::ODBC; DBI->trace(DBD::ODBC->parse_trace_flags('odbcconnection|odbcunicode'));
and run it with DBI_TRACE set to 15 and mail me the output. e.g.,
DBI_TRACE=15 perl your_test_script.pl
send me the script and output. Also could you tell me what the actual column types are in your Sybase schema. Also run the following (substituting for DSN, username and password) and send the output:
perl -MDBI -e '$h = DBI->connect("dbi:ODBC:MYDSN","USER","PASS");$x = $h->type_info_all;use Data::D +umper;print Dumper($x);'
Martin
Direct Responses: 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.