I am converting text data from another database into SQLite. Some text
data has embedded apostrophes like this:
This was George's big day
Other data has embedded double quotes like this:
The box is 3" wide
I am generating INSERT INTO statements for thousands of records to be used
in a Windows script to move the data into SQLite. I am needing to use
different statement (with different delmiters) for each of the above
2 scenarios:
INSERT INTO tbl VALUES("This was George's big day");
INSERT INTO tbl VALUES('The box is 3" wide');
Double-quotes wrap the apostrophe in #1, apostrophes wrap the double-quote
in #2. But this means I need to parse the data content for every field in
order to generate the INSERTs. Is there a single set of delimiters that
would handle both scenarios without having to parse the data first?
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christopher F. Martin
School of Medicine
Center for Digestive Diseases & Nutrition
CB# 7555, 4104 Bioinformatics Bldg.
University of North Carolina at Chapel Hill
Chapel Hill, North Carolina 27599-7555
Phone: 919.966.9340 Fax: 919.966.7592
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
