You could use the api call that binds variables to parameters in the sql.
The sql parser doesn't read the data when you do, so it won't matter
what's in it:
sqlite3_bind_text( pStmt, Index, pointer_to_column_data,
column.size(), SQLITE_STATIC );
sql:
insert into mytable (x) values(?);
On 5/25/05, Sankara Narayanan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a tricky situation where I have strings in my data that have both
> single and double quotes. I am using the C APIs of sqlite3_prepare and
> sqlite3_exec to insert data into the database. How do I prepare the query
> string in such case where the string data have both single and double
> quotes.
>
> FYI, The string data are some meta data information and hence they can
> contain all possible characters with any possible combination and there is
> not restriction for special characters.
>
> Your suggestions are highly appreciated.
>
> Thank you,
>
> With regards,
> Sankara Narayanan B.
>
--
---
You a Gamer? If you're near Kansas City:
Conquest 36
https://events.reddawn.net
The Castles of Dereth Calendar: a tour of the art and architecture of
Asheron's Call
http://www.lulu.com/content/77264
