Andrew Wood schrieb: > I apologise if this is in the documentation but I cant seem to follow it. > > Is there a function in the C/C++ API which will escape an array of > binary data. For example in MySQL there is the following function: > > mysql_real_escape_string(&conn,out,in,length); > > What Id like to do is take a char array in C, escpape it and drop it > into a plain text SQL string which could then be passed to > sqlite3_get_table()
Sounds like the wrong approach. Use bind variables and a different query API if you need this. See sqlite3_prepare_v2, sqlite3_bind etc. But if you really need it, you can create blob literals easily yourself, its just the hex string in quotes with a x or X prefixed. http://sqlite.org/lang_expr.html Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [email protected] Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
