Hello P,
If you use parameterized inserts doesn't this whole issue just go
away? I used to have to mess with escaping strings and so forth. Now
that I compile and bind the strings to the statements, I don't have to
mess with it any more.
C
Thursday, May 8, 2008, 9:11:40 AM, you wrote:
PK> On 5/8/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> 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');
PK> INSERT INTO tbl VALUES ('This was George''s big day');
PK> INSERT INTO tbl VALUES ('The box is 3" wide');
PK> The text delimiter in SQL is '
PK> You escape a ' with another '
>>
>> 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
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>>
PK> _______________________________________________
PK> sqlite-users mailing list
PK> sqlite-users@sqlite.org
PK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards,
Teg mailto:[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
