> Hi Guys > > I'm having some problems dealing with the character '. Sqlite thinks > fair enough that it should terminate the string, which I would like it > to avoid. Are there any solutions to my problems. > > Thanks, Niels
Hello Niels try: sqlite> CREATE TABLE t (id INTEGER, bez TEXT); sqlite> INSERT INTO t (id, bez) values (1,"'"); sqlite> INSERT INTO t (id, bez) values (2,''''); sqlite> SELECT * FROM t; 1|' 2|' Does this already solve your problem, or do you need something in another context? Philipp
