BigMemory 4.4.0 | Product Documentation | BigMemory Max Developer Guide | Searching with BigMemory SQL | SQL Syntax and Examples | Data Types
 
Data Types
To be searchable using BigMemory SQL, the data type of an Attribute must be one of the following:
*boolean
*byte
*char
*float
*short
*long
*int
*double
*date
*sqldate
*String
The value of an Attribute in the WHERE clause must follow these data type rules:
*Except for integer and string types, an explicit cast must indicate the data type.
*Values for string, boolean, date, and sqldate must be surrounded by single quotes.
Data Types Examples
select * from Person where age = 11 // age is of type int
select * from Person where name = 'Mary' // name is of type String
select * from Person where gender = (char)'M'
select * from Person where isMale = (bool)'true'
select * from Person where age = (byte)11
select * from Person where age = (short)11
select * from Person where age = (long)11
select * from Person where age = (double)11.1
select * from Person where birthDate = (date)'2003-01-10T14:25:22'
The data type name is case-sensitive. For example, use lowercase 'd' in (double) to indicate a primitive of type double.