error: Apostrophe not preceded by \ (in CREATE TABLE tb_cammonitor_configs

最新推荐文章于 2017-04-18 10:52:41 发布

原创最新推荐文章于 2017-04-18 10:52:41 发布 · 399 阅读

0 ·

CC 4.0 BY-SA版权

异常处理办法记录专栏收录该内容

7 篇文章

订阅专栏

error: Apostrophe not preceded by \ (in CREATE TABLE tb_cammonitor_configs

出错地方：
<string name="table_sql">
CREATE TABLE tb_cammonitor_configs (
_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name VARCHAR(30) NULL,
ip VARCHAR(64) NULL,
port NUMERIC NULL,
username VARCHAR(64) NULL,
password VARCHAR(64) NULL,
client_dir TEXT NULL,
connect_type NUMERIC DEFAULT '1' NULL
);
</string>

修改：
<string name="table_sql">
CREATE TABLE tb_cammonitor_configs (
_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name VARCHAR(30) NULL,
ip VARCHAR(64) NULL,
port NUMERIC NULL,
username VARCHAR(64) NULL,
password VARCHAR(64) NULL,
client_dir TEXT NULL,
connect_type NUMERIC DEFAULT \'1\' NULL
);
</string>

做转义处理，'转义\'