You can use the hex code of the non-printable character: update tableA set field1 = "line1 x'0a' line2"
-Toby >Are there any docs for how to write SQL for special characters like >return and linefeed? > >On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is >\n so an SQL might be something like: > >UPDATE TableA SET Field1 = "line 1\nline 2" > >which would produce: > >line 1 >line 2 > >in Field1 > >Is there somewhere I can find out how I can set special characters in SQLite? > > >Thanks > >Greg _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users