Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-29 Thread Martin Jenkins
fangles wrote: When I have text pasted into an sqlite string field, it is stored okay but when I retrieve a string, it is truncated at the first CR (0D). Hi fangles, Did you get this sorted? Martin - To unsubscribe,

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-26 Thread John Stanton
P Kishor wrote: On 3/25/07, fangles <[EMAIL PROTECTED]> wrote: SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-26 Thread P Kishor
On 3/25/07, fangles <[EMAIL PROTECTED]> wrote: SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the string in a debug

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-26 Thread Martin Jenkins
fangles wrote: SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the string in a debugger, and the debugger just ha

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-25 Thread fangles
SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the string in a debugger, and the debugger just happens to show on

[sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-24 Thread fangles
When I have text pasted into an sqlite string field, it is stored okay but when I retrieve a string, it is truncated at the first CR (0D). Does anyone know how to handle this by any chance? -- View this message in context: http://www.nabble.com/Store-and-retreive-0D0A-%28CRLF%29-in-string-field