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

boolean

opaque

blob

double

float

real

double

datetime

datetime