Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Perl DBI adding some, not all, records to MySQL database

by snopal (Pilgrim)
on Jul 06, 2007 at 13:58 UTC ( [id://625266]=note: print w/replies, xml ) Need Help??


in reply to Perl DBI adding some, not all, records to MySQL database

The method you are using to split the fields may be at issue.

My experience with Text::CSV_XS is that it is necessary to use binary mode or some records will be null when characters in the line are out of ascii range.

It may also be possible that your EOL character is getting in the way. Properly chomping the lines as you parse them can help alot.

These suggestions are merely conjecture since we don't have this part of the code to evaluate.

  • Comment on Re: Perl DBI adding some, not all, records to MySQL database

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://625266]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-04-25 19:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found