Re: [sqlite] Using TEXT vs BLOB

On Fri, 10 Nov 2006, toofah wrote: I am somewhat new to sqlite and am a novice at setting up databases for a product, so here goes: Gary, This is a good learning situation. Lots of useful information on the web site: . What are the Advantages/Disadvantages to

[sqlite] Using TEXT vs BLOB

I am somewhat new to sqlite and am a novice at setting up databases for a product, so here goes: What are the Advantages/Disadvantages to using TEXT vs. BLOB to store and access data in sqlite...or are they pretty equal. Most of my data is string data...but for some reason the previous