P is for Practical | |
PerlMonks |
Re^4: DBD::CSV works with text, but not numbersby Tux (Canon) |
on May 20, 2016 at 12:03 UTC ( [id://1163619]=note: print w/replies, xml ) | Need Help?? |
Digging a bit deeper, just to satisfy my own curiosity (as I could not remember lower-casing the headers), here's the cause of your column name folding: From the SQL::Statement manual pages:
As select * from selects on a wildcard, this situation comes into effect. I'll add an explicit note to the docs of DBD::CSV. Note in case of DBD::CSV that you can check what the driver's view on reality is by inspecting $dbh->{csv_tables}{tablename}{col_names}. My test showed me that this still holds the original folding. Personally, I always use NAME_lc in all my database interfaces, so I never hit this problem. Enjoy, Have FUN! H.Merijn
In Section
Seekers of Perl Wisdom
|
|