Re: How do I get a flatfile containing UTF8 characters inserted using the DBI module?

If you use DBD::CSV you can access the CSV file with the same DBI/SQL statements you'd use to access Oracle so you can just SELECT what you want from the CSV and then loop through a fetch INSERTing into Oracle as you go. You'll want the latest DBD::File (a prereq for DBD::CSV) since it fixes a bug in UTF8 handling (it's found in the latest DBI release). You'll almost certainly want to use placeholders for your INSERT.

Comment on Re: How do I get a flatfile containing UTF8 characters inserted using the DBI module?

Replies are listed 'Best First'.
Re^2: How do I get a flatfile containing UTF8 characters inserted using the DBI module? by eraymond (Novice) on Feb 16, 2005 at 14:49 UTC
Thanks, I will give it a go. I was trying to stray from inserting into the table without knowing exactly what data it will be inserting. I was creating a separate .sql file to check then run after it looked good. Thanks.	[reply]