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

Related tasks

Dropping an Index

Creating an Index

Dropping a Table

Creating a New Table

Contents

Index

Search Results

SQL Data Type Mapping