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 on

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

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

Re: [sqlite] compare open table and attached database table

Rich Shepard wrote: > > On Sun, 18 Feb 2007, fangles wrote: > >> Thank you Igor, that's fantastic. I'm reading lots of SqLite tutorials >> but >> a lot of the SQL is so far out of my brain's reach that it doesn't make >> sense to me. And I

Re: [sqlite] Search all collumns with LIKE at once

Martin Jenkins-2 wrote: > > fangles wrote: >> PK? I'm sorry but I am not familiar with that term.. > > Sorry, in this example a Primary Key is a column (eg an integer) which > uniquely specifies a row in a table. > > In the example above you: > >

Re: [sqlite] Search all collumns with LIKE at once

Martin Jenkins-2 wrote: > > fangles wrote: >> I'm currently searching through all columns in a table to see if any >> match >> the search text and the query is rather cumbersome. Is there a way to use >> a >> loop to go through all available columns b

Re: [sqlite] Search all collumns with LIKE at once

Martin Jenkins-2 wrote: > > fangles wrote: >> I'm currently searching through all columns in a table to see if any >> match >> the search text and the query is rather cumbersome. Is there a way to use >> a >> loop to go through all available columns b

[sqlite] Search all collumns with LIKE at once

I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? SELECT * FROM addresses WHERE title LIKE '% + searcht

Re: [sqlite] compare open table and attached database table

Igor Tandetnik wrote: > > fangles <[EMAIL PROTECTED]> wrote: >> Hello, I am trying to compare a currently opened database table with >> a table from an attached database. Both tables have identical >> structures but the attached table has an extra record. >>

[sqlite] compare open table and attached database table

Hello, I am trying to compare a currently opened database table with a table from an attached database. Both tables have identical structures but the attached table has an extra record. I wanted to do two queries. The first lists records from the internal table NOT CONTAINED IN the attached tabl