On 31-12-2011 22:16, Kai Peters wrote: > > Hi, > > how can I insert a control character like carriage return? > > Something like: > > update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2 > > Thanks for any help > Kai
on a Windows-machine, this works: press, and keep pressed, the ALT-key, and type 10 on your numeric keypad while entering the symbol for '\r' you'll get : sqlite> select 'testâ—™abc'; ...> test abc sqlite> (i hope this looks good when process through some nntp-software ;) -- Luuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
