Data Types
To be searchable using BigMemory SQL, the data type of an Attribute must be one of the following:
![*](bullet.gif)
boolean
![*](bullet.gif)
byte
![*](bullet.gif)
char
![*](bullet.gif)
float
![*](bullet.gif)
short
![*](bullet.gif)
long
![*](bullet.gif)
int
![*](bullet.gif)
double
![*](bullet.gif)
date
![*](bullet.gif)
sqldate
![*](bullet.gif)
String
The value of an Attribute in the WHERE clause must follow these data type rules:
![*](bullet.gif)
Except for integer and string types, an explicit cast must indicate the data type.
![*](bullet.gif)
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.