"Greg Robertson" <trifus...@gmail.com> 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 have just one line when you view the data in SQLite Manager, it's more likely that the data in the table is actually correct but the UI presents it incorrectly. To confirm, try this statement: select hex(Field1) from Table1; Watch for 0A octet in the hex representation. > Perhaps it is just FireFox parsing the > special character? Perhaps. In any case, this should work: UPDATE TableA SET Field1 = 'line 1' || x'0a' || 'line 2'; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
