zavisi od rdbms-a ... na primer
Code:
mysql> create table tx (x varchar(100);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> create table tx (x varchar(100));
Query OK, 0 rows affected, 2 warnings (0.04 sec)
mysql> insert into tx values ('o''conors');
Query OK, 1 row affected (0.01 sec)
mysql> select * from tx;
+----------+
| x |
+----------+
| o'conors |
+----------+
1 row in set (0.00 sec)
mysql> insert into tx values ('o\'conors');
Query OK, 1 row affected (0.00 sec)
mysql> select * from tx;
+----------+
| x |
+----------+
| o'conors |
| o'conors |
+----------+
2 rows in set (0.00 sec)
mysql>