<[email protected]> wrote in message news:[email protected] > I cannot use parameterized queries because the queries are more > complex than the simple one that I wrote
I'm not sure how your conclusion follows from the premise. You can use parameters with any query, no matter how complex. > I've sqlite3_get_table sqlite3_get_table requires that the query be in UTF-8. If you insist on using it, then you will have to convert your Unicode string to UTF-8, no way around it. On the other hand, you can use sqlite3_prepare16[_v2] directly on a UTF-16 string (which may or may not be helpful, depending on your platform: on some platforms sizeof(wchar_t)==2 and wstring holds a 16-bit string that can be passed directly to sqlite3_prepare16, on others sizeof(wchar_t) == 4 and wstring would require conversion anyway). Note that you can happily use sqlite3_prepare16 on a query without any parameters, if for some reason you are averse to them. It's still better than sqlite3_get_table. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
