Re: [sqlite] How to insert control characters into a table

2012-01-01 Thread Yuriy Kaminskiy
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 update ... 'Male' || X'0D' || 'Female' ... ___ sqlite-users mailing

Re: [sqlite] How to insert control characters into a table

2012-01-01 Thread Kees Nuyt
On Sat, 31 Dec 2011 13:16:58 -0800, 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 Line endings can be included in text literals:

Re: [sqlite] How to insert control characters into a table

2011-12-31 Thread Luuk
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

[sqlite] How to insert control characters into a table

2011-12-31 Thread Kai Peters
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 ___ sqlite-users mailing list sqlite-users@sqlite.org