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

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

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

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