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

[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:

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: > > selec

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 by som

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 by som

[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 '% +

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