[AccessD] Number vs text data type

Hi all

If you are bored to death by the discussion on datatypes why not use a
typeless (and completely free public domain) engine!

  http://www.sqlite.org/

  http://www.sqlite.org/datatypes.html

  http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

It handles TB size databases and claims to be faster than MySQL. It
is, however, not well suited for multiuser applications.

/gustav


> Whoa, whoa, wait a second! I didn't mean to imply that
> there are never cases where storing a number as text 
> doesn't make sense, in fact I said exactly that in my 
> message (granted, in just one line, but sheesh!). What you 
> cite are "compelling reasons" to store a number as text. 
> But when there is no compelling reason to store a numeric 
> value as text it should be stored as a number, I believe 
> that and have far fewer problems by following that 
> strategy. 

> Ron