[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] How to insert control characters into a table
From:       Luuk <luuk34 () gmail ! com>
Date:       2011-12-31 22:15:40
Message-ID: 4EFF898C.3040507 () gmail ! com
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]