Operation, Supported data types – Sun Microsystems Sun StorageTek 5800 User Manual
Page 116
Operation
The query format is similar to the where clause of an SQL query. The two main differences are
that 5800 system queries do not contain embedded subqueries, and that the only “columns” that
are available are the attributes defined in the 5800 system schema.
Many features of the underlying metadata database’s own query language can be used in
queries. There is a recommended subset of queries, however, that is most likely to be portable
from the 5800 system emulator to a live 5800 system cluster. That subset is described in the
sections
“Supported Expression Types” on page 121
and
“Queries Not Supported in Version
. These are the query expression types that should work identically on the 5800
system emulator and a live 5800 system cluster.
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.
Operation
Sun StorageTek 5800 System Client API Reference Manual • June 2008
116