Subject | Blob or VarChar |
---|---|
Author | zifnabbe |
Post date | 2004-06-22T21:36:31Z |
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
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