revDatabaseColumnTypes - data type definitions?

[Steve Denney]

Hi, I've already posted this this Q in the comm. dev. forum...
http://forums.runrev.com/phpBB2/viewtop ... 485#p33485
Where it's been suggested I post here.

The Q concerns revDatabaseColumnTypes which returns the following data types (the following is from from the dictionary):
BIT, CHAR, STRING, WSTRING, BLOB, TIMESTAMP, DATE, TIME, DATETIME, FLOAT, DOUBLE, INTEGER, SMALLINT, WORD, BOOLEAN, LONG
...but i can't find any run-rev definition of what these actually mean (or how they relate to other database data types esp. SQL and MS Access).
Like, I can take my best guess--but it'd be nice to have the actual definition (for myself and so I can pass it on).
Surely the definitions muct be somewhere, I just can't find them
Steve

[Klaus]

Hi Steve,

well the docs say:
...
The POSSIBLE data types are:
...
So to me this is more an example that an actual documentation!

And as someone in the other thread says, this is not LiveCode specific but depends on the used database.
So you will need to look for furhter infos about these types in the docs of the appropriate DATABASE like
MySQL, SQLite, MS SQL or whatever.


Best

Klaus

[Steve Denney]

Well, they're runRev terms, from the LC/Revolution dictionary, returned by LC as datatypes. If they were the datatype terms used by other database vendors I'd know exactly what they meant because they all provide concise definitions.
But they are not
Mainly, the LC data types appear to come from C and C++ (just what i get from searching) so those are the definitions I'll use. It's not actually for me. I've written the app, sure, but others will be installing it and setting it up to suit whatever database they use. They're used to MS access & SQL (and potentially other installers may have different databases). Their data type names don't match with each other, never mind the ones LC uses.
I'm starting to think there's no runRev definition as such (for the LC data types). No matter, would've been nice, that's all.
Steve