Subject Blob or VarChar
Author zifnabbe
Hi,

I've read some articles on Blob and VarChar, but I'm still not sure
what to use. I need to store some text (configuration templates)
information from a delphi application into a database. I think a max
of 2000 chars (at the moment all templates are < 1000 chars).

What is the best way to store this data in? Using VarChar or Blob's?

What if I change my application one day and I would make it possible
that a user can choose the database? Does Blob give more
incompatability problems than VarChar?

Thanks in advance,
Tom