Re: [sqlite] Writing SQL with special characters

2009-02-27 Thread Igor Tandetnik
"Greg Robertson" wrote in message news:151e70a00902270415t55996dccs5035ee4209f97...@mail.gmail.com > I have tried out both methods in the FireFox extension SQLite Manager > and neither appears to work. Define "doesn't work". Do you get an error? If the statement succeeds but the value appears to

Re: [sqlite] Writing SQL with special characters

2009-02-27 Thread Greg Robertson
I have tried out both methods in the FireFox extension SQLite Manager and neither appears to work. Perhaps it is just FireFox parsing the special character? Greg -- You can use the hex code of the non-printable character: update tableA set field1 = "line1 x'0a' line2" -Toby >A

Re: [sqlite] Writing SQL with special characters

2009-02-26 Thread Toby Bascom
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

Re: [sqlite] Writing SQL with special characters

2009-02-26 Thread Igor Tandetnik
"Greg Robertson" 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 somethin

[sqlite] Writing SQL with special characters

2009-02-26 Thread Greg Robertson
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 ther