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
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:
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
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
4 matches
Mail list logo