Supported Data Types

• Long— 8-byte integer value.

• Double— 8-byte IEEE 754 double-precision floating point value.

• String— now allows all Unicode values from the Basic Multilingual Plane (BMP). The encoding used is UTF-8. the schema definition of each String attribute must specify a length. String(N) is used as the convention to refer to the type of a String attribute whose length is set to N.

• char— similar to String, except that it is limited to 8-bit characters in the ISO-8859-1 (Latin-1) character set.

• Date— corresponds to the JDBC SQL DATE type. Year/Month/Day.

• Time— corresponds to the JDBC SQL TIME type. The Java java.sql.Time type only allows specification of whole seconds.

• Timestamp— corresponds to the JDBC SQL TIMESTAMP type with precision 3 (absolute Year/Month/Day/Hour/Minute/Second/Millisecond).

• Binary— string of binary bytes.

• Objectid— similar to binary, with internal support for sub-fields. Reserved for use by the system.object_id field. Other fields that must store an OID should use the string or binary type for that field.