SQL Data Type Mapping
ActiveSpaces uses a small set of data types for storing data in the data grid. Several SQL data types have been mapped to each of the ActiveSpaces data types. The following table lists each data type and the SQL data types that have been mapped to it:
| ActiveSpaces Data Type | SQL Data Types |
|---|---|
| string |
char varchar longvarchar text character varying |
| long |
int bit bigint tinyint smallint integer boolean |
| opaque |
blob binary varbinary longvarbinary |
| double |
float real double |
| datetime |
datetime date time timestamp |