开发者

Ampersand in sqlite query

开发者 https://www.devze.com 2023-01-02 18:06 出处:网络
How to construct sqlite query containing ampersand in filter: SELECT i开发者_高级运维d FROM mediainfo WHERE album=\"Betty & Kate\";

How to construct sqlite query containing ampersand in filter:

SELECT i开发者_高级运维d FROM mediainfo WHERE album="Betty & Kate";

I use sqlite C interface (sqlite3_bind_text() and ? marks while query building) but neither C query nor SQLite Administrator return any data


& is not a special character either in C strings or in SQL strings, so I don't think that's the problem. Try the same query from a tool like SQLite Database Browser.

0

精彩评论

暂无评论...
验证码 换一张
取 消