Re: [sqlite] Store and retreive 0D0A (CRLF) in string field
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, send email to [EMAIL PROTECTED] -
Re: [sqlite] Store and retreive 0D0A (CRLF) in string field
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 string in a debugger, and the debugger just happens to show only the first line). Use sqlite3_column_bytes[16] to convince yourself that SQLite gives you the complete string. Igor Tandetnik Thanks for that rather blunt reply. .. I'd rather have "blunt" replies from Igor than emotional replies from anyone else. And, as far as I can see, the reply was about the best that anyone could have given. It was far better than anything I could have contributed. When asking questions, please provide information on how you are using SQLite, what "wrapper" or language you are using, version number of the software, possibly even steps to reproduce the problem, etc. This is an email list, not a class. And, yes, it is still free. Take it as it is, and give back. Ask questions, and if you can, answer some as well, so folks who really know (and I am not one of them) can focus on answering the really difficult questions. "Blunt" is not a synonym for "complete" or "informative" unless the word means something else in the South Pacific. A better response would be "Thank you Igor for taking the time to answer my question and saving me the effort of doing a little research". - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Store and retreive 0D0A (CRLF) in string field
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 debugger, and the debugger just happens to show only the first line). Use sqlite3_column_bytes[16] to convince yourself that SQLite gives you the complete string. Igor Tandetnik Thanks for that rather blunt reply. .. I'd rather have "blunt" replies from Igor than emotional replies from anyone else. And, as far as I can see, the reply was about the best that anyone could have given. It was far better than anything I could have contributed. When asking questions, please provide information on how you are using SQLite, what "wrapper" or language you are using, version number of the software, possibly even steps to reproduce the problem, etc. This is an email list, not a class. And, yes, it is still free. Take it as it is, and give back. Ask questions, and if you can, answer some as well, so folks who really know (and I am not one of them) can focus on answering the really difficult questions. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Store and retreive 0D0A (CRLF) in string field
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 happens to show only the first line). Use sqlite3_column_bytes[16] to convince yourself that SQLite gives you the complete string. Thanks for that rather blunt reply. What was blunt about it? You asked a question regarding odd behaviour that nobody else has seen without providing any context. Igor confirmed that SQLite didn't behave like that and suggested possible explanations for what you saw. If you don't like the answer, ask better questions. Anyway, I thought you Ozzies liked a bit of direct speaking. ;) Martin - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Store and retreive 0D0A (CRLF) in string field
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 only the first line). Use sqlite3_column_bytes[16] to convince yourself that SQLite gives you the complete string. Igor Tandetnik Thanks for that rather blunt reply. I had already figured out the data was there by using a professional sqlite tool. Now I just have to figure out how my compiler is handling the returned data. -- View this message in context: http://www.nabble.com/Store-and-retreive-0D0A-%28CRLF%29-in-string-field-tf3461423.html#a9666968 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -