Re: [sqlite] Saving BLOBs in Sqlite

On Sat, May 08, 2004 at 03:32:28AM -0400, aducom wrote: > You can use escape routines of your own but if other > app's will need the same database you might face compatibility > problems. It's been an isue to us rather a while now. At the cost of boosting each blob's size by about 30%, base64

[sqlite] testing for existence of an entity

this is likely a common and easy answer, so my for not being able to figure it out. How do I test for the existence of a table or a view so I can do something like... if exists then DROP else CREATE ()... should I use CASE, or is there some other way?

Re: [sqlite] phpsqliteadmin

Try joining the mailing list for phpSQLiteAdmin (you can find details here: http://www.phpguru.org/static/phpSQLiteAdmin.html). -- Richard Heyes - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [sqlite] Saving BLOBs in Sqlite

SQLite saves data as null terminated strings. So it's only capable to store CLOBS. In cvs there seems to be two functions to escape null characters but they are not available in the sqlite.dll version 13. It appears that all development effort is put into a complete new version, so I'm affraid