向sqlite数据库中插入的字符串有单引号怎么办

因为插入的字符串被从单引号处截断，造成SQL语句的语法错误！

解决方法：遍历字符串，把一个（'）换成两个（' '）就可以了，在C#里，其实用str.Replace("'", "''")就可以了，这是因为SQL是用两个单引号来代替一个单引号的。

下面是我用PRO*C实现的，可在VC中运行。

EXEC SQL BEGIN DECLARE SECTION

char name[]="张三"

char sql[]="insert into MyTable(name) values(:=name)"

EXEC SQL END DECLARE SECTION

EXEC SQL EXECUTE IMMEDIATE :sql

select path || '%' from t_category where depth = 0 and type = 0

用'||'拼接字符串

比如path是/1001/的话 那结果就是/1001/%

数字相加

SELECT 'A'+'B' 结果为0

SELECT "A"+"1" 结果为1

SELECT "A"+1 结果为1

SELECT 2+1 结果为3

=在“+”运算中，SQLite将字符串非数字串都当作0处理了

|| String Concatenation

* Arithmetic Multiply

/ Arithmetic Divide

% Arithmetic Modulus

+ Arithmetic Add

– Arithmetic Subtract

<< Bitwise Right shift

>> Bitwise Left shift

& Logical And

| Logical Or

< Relational Less than

<= Relational Less than or equal to

> Relational Greater than

>= Relational Greater than or equal to

= Relational Equal to

== Relational Equal to

<> Relational Not equal to

!= Relational Not equal to

IN Logical In

AND Logical And

OR Logical Or

LIKE Relational String matching

GLOB Relational Filename matching

---