Putting this here in the hope it comes in useful for someone sometime. Have a table which has some text fields in it. For use with an old system the text fields had newlines in which were expressed with C escapes: 'firstline\nsecondline'. Here's how I fixed it:
UPDATE myTable SET textfield=REPLACE(textfield,'\n',x'0A'); If anyone can see a better way, or wants to note some hidden danger with the above, I welcome it. Including if there's a problem depending on whether the field is UTF-8 or UTF-16. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
