Re: [sqlite] Loss of Binary Data in Dump File

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/27/2010 02:20 PM, Art Age Software wrote: > I guess the next question is how do I force the affinity to "blob" The affinity is the type that SQLite will make a reasonable attemp to convert to for that column, but leave the value as is if the

Re: [sqlite] Loss of Binary Data in Dump File

Thanks Roger. That does seem to be the problem as the type of the columns is coming back as "text." I guess the next question is how do I force the affinity to "blob" using the PHP PDO API... Sam On Wed, Oct 27, 2010 at 2:12 PM, Roger Binns wrote: > -BEGIN PGP SIGNED

Re: [sqlite] Loss of Binary Data in Dump File

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/27/2010 11:48 AM, Art Age Software wrote: > New to this list and hoping someone can help. I have a sqlite3 > database that contains a couple of tables that have binary data in > BLOB columns. Note that there is column affinity, but the data

[sqlite] Loss of Binary Data in Dump File

Hi All, New to this list and hoping someone can help. I have a sqlite3 database that contains a couple of tables that have binary data in BLOB columns. I know the data is in there and stored correctly because the application accessing the database can retrieve the column data just fine. The

[sqlite] error whit sqlite3_exec() and struct

Hi to everyone.This is my first post to the sqlite-users postlist so i am sorry if i don't respect some rule. My question is about the sqlite3_exec() function.I have the following code : typedef struct _object object; int main() { /* ... */ my_object*object; object

Re: [sqlite] Changing Date Format

"Max Vlasov" wrote... > On Wed, Oct 27, 2010 at 8:09 AM, jose isaias cabrera > wrote: > >> >> What I would like to do is a call that can fix the dates to the correct >> format, ie. -MM-DD, so that the final data looks like this, >> >> > How about > > UPDATE Table1 Set

Re: [sqlite] Changing Date Format

"BareFeetWare" wrote... > On 27/10/2010, at 3:09 PM, jose isaias cabrera wrote: > >> I know I can do a bunch of sets, such as this one, >> >> UPDATE table1 set d1 = '2010-01-01' >> where >> d1 = '2010-1-1'; >> >> but that is a lot of coding. > > > Perhaps something like: > > create table

Re: [sqlite] WHERE + GROUP BY and indices

Jean-Marie CUAZ wrote: > When using a SELECT query with WHERE and GROUP BY clauses, does it make > sense to add the GROUP BY terms in an index allready containing the > columns used in the WHERE clause ? In some cases, it might help. If you have something like select * from t

[sqlite] WHERE + GROUP BY and indices

Hello, When using a SELECT query with WHERE and GROUP BY clauses, does it make sense to add the GROUP BY terms in an index allready containing the columns used in the WHERE clause ? If yes, should the columns used in the GROUP BY clause be at the beginning of the columns order of the index ?