"Greg Robertson" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
