Re^2: CSV tab-delimited not space-delimited

If $dbh->{csv_allow_whitespace} = 1; doesn't address your problem, you have something very odd going on.

Then somethings odd is going on, adding the options right doesn't solve the problem.

The scrambling occours on retrival from a SELECT. No errors or warnings (with RaiseError). And now I double checked, but the characters are spaces and tabs.

Just to be precise the versions are

perl	5.10.1
DBD::CSV	0.2600

Comment on Re^2: CSV tab-delimited not space-delimited

Replies are listed 'Best First'.
Re^3: CSV tab-delimited not space-delimited by Tux (Canon) on Jun 25, 2010 at 10:22 UTC
What is your version of Text::CSV_XS? A problem as you describe has been fixed in version 0.63: `2009-03-20 0.63 - H.Merijn Brand <h.m.brand@xs4all.nl> * Fixed allow_whitespace with sep_char = TAB (RT#44402)` [download] Current DBD::CSV is 0.29, and Text::CSV_XS is 0.73 Enjoy, Have FUN! H.Merijn	[reply] [d/l]
Re^4: CSV tab-delimited not space-delimited by mellon85 (Monk) on Jun 26, 2010 at 14:06 UTC
I'm using Text::CSV_XS version 0.70 I'll upgrade to the latest and report the result update Upgrading the the latest version of DBD::CSV and Text::CSV_XS didn't solved the problem	[reply]