"Greg Robertson" <trifus...@gmail.com> wrote in message news:151e70a00902261923u203fdcd0yb334e5b87dd3f...@mail.gmail.com > 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"
With SQLite, carriage return is in no way special. You just enter it literally: UPDATE TableA SET Field1 = 'line 1 line 2'; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
