Data type | RapidClipse default mapping | Generated Javacode (example) |
---|---|---|
CHARACTER(n) A Unicode String. This type is supported for compatibility |
with other databases and older applications. The difference |
to The maximum precision is |
is a size constraint; only the actual data is persisted. The whole text is kept in memory when using this data type. |
-
|
| |||||||||||||||||
CHAR(n) A Unicode String. This type is supported for compatibility |
with other databases and older applications. The difference |
to The maximum precision is |
is a size constraint; only the actual data is persisted. The whole text is kept in memory when using this data type. |
-
|
| ||||||||||||||||
NCHAR(n) |
A Unicode String. This type is supported for compatibility |
with other databases and older applications. The difference |
to The maximum precision is |
is a size constraint; only the actual data is persisted. The whole text is kept in memory when using this data type. |
|
| ||||||||||||||||
INT Possible values: -2147483648 to 2147483647. |
Hibernate default mapping |
-
| ||||||||||
INTEGER Possible values: -2147483648 to 2147483647. |
-
-Hibernate default mapping |
| ||||||||||
MEDIUMINT Possible values: -2147483648 to 2147483647. |
-
-Hibernate default mapping |
| ||||||||||
INT4 Possible values: -2147483648 to 2147483647. |
Hibernate default mapping |
-
| ||||||||||
SIGNED Possible values: -2147483648 to 2147483647. |
Hibernate default mapping |
-
| ||||||||||
BOOLEAN Possible values: |
Hibernate default mapping |
-
| ||||||||||
BIT Possible values: |
Hibernate default mapping |
-
| ||||||||||
BOOL Possible values: |
Hibernate default mapping |
-
| ||||||||||
TINYINT Possible values are: -128 to 127. |
-
-Hibernate default mapping |
| ||||||||||
SMALLINT Possible values: -32768 to 32767. |
Hibernate default mapping |
-
| ||||||||||
INT2 Possible values: -32768 to 32767. |
-
-Hibernate default mapping |
| ||||||||||
YEAR Possible values: -32768 to 32767. |
-
-Hibernate default mapping |
| ||||||||||
BIGINT Possible values: -9223372036854775808 to 9223372036854775807. |
Hibernate default mapping |
-
| ||||||||||
INT8 Possible values: -9223372036854775808 to 9223372036854775807. |
-
-Hibernate default mapping |
| ||||||||||
IDENTITY Auto-Increment value. Possible values: -9223372036854775808 to 9223372036854775807. Used values are never re-used, even when the transaction is rolled back. |
Hibernate default mapping |
-
| ||||||||||
DECIMAL Data type with fixed precision and scale. This data type is recommended for storing currency values. |
Hibernate default mapping |
-
| ||||||||||||||||||||
NUMBER Data type with fixed precision and scale. This data type is recommended for storing currency values. |
Hibernate default mapping |
-
| ||||||||||
DEC Data type with fixed precision and scale. This data type is recommended for storing currency values. |
-
-Hibernate default mapping |
| ||||||||||
NUMERIC Data type with fixed precision and scale. This data type is recommended for storing currency values. |
Hibernate default mapping |
-
| ||||||||||
DOUBLE A floating point number. Should not be used to |
represent currency values, because of rounding problems. |
-
-Hibernate default mapping |
| ||||||||||
FLOAT A floating point number. Should not be used to |
represent currency values, because of rounding problems. |
Hibernate default mapping |
-
| ||||||||||
FLOAT8 A floating point number. Should not be used to |
represent currency values, because of rounding problems. |
Hibernate default mapping |
-
| ||||||||||
REAL A single precision floating point number. Should not be used to |
represent currency values, because of rounding problems. |
-
|
| |||||||||||||||
FLOAT4 A single precision floating point number. Should not be used to |
represent currency values, because of rounding problems. |
-
|
| |||||||||||||||
TIME The time data type. The format is hh:mm:ss. |
-
-Hibernate default mapping |
| ||||||||||
DATE The date data type. The format is yyyy- |
Hibernate default mapping |
-
| |||||||||||
TIMESTAMP The timestamp data type. The format is yyyy- |
-
-Hibernate default mapping |
| ||||||||||
DATETIME The timestamp data type. The format is yyyy- |
Hibernate default mapping |
-
| |||||||||||
SMALLDATETIME The timestamp data type. The format is yyyy- |
-
-Hibernate default mapping |
| ||||||||||
BINARY Represents a byte array. For very long arrays, use BLOB. The maximum size is 2 GB, but the whole object is kept in |
memory when using this data type. The precision is a size |
constraint; only the actual data is persisted. For large text |
BLOB
or CLOB
should data BLOB or CLOB should be used. |
Hibernate default mapping |
-
| |||||||||||
VARBINARY Represents a byte array. For very long arrays, use BLOB. The maximum size is 2 GB, but the whole object is kept in |
memory when using this data type. The precision is a size |
constraint; only the actual data is persisted. For large text |
BLOB
or CLOB
should data BLOB or CLOB should be used. |
-
-Hibernate default mapping |
| ||||||||||
LONGVARBINARY Represents a byte array. For very long arrays, use BLOB. The maximum size is 2 GB, but the whole object is kept in |
memory when using this data type. The precision is a size |
constraint; only the actual data is persisted. For large text |
data BLOB or |
CLOB
CLOB should be used. |
-
-Hibernate default mapping |
| ||||||||||
RAW Represents a byte array. For very long arrays, use BLOB. The maximum size is 2 GB, but the whole object is kept in |
memory when using this data type. The precision is a size |
constraint; only the actual data is persisted. For large text |
data BLOB or |
CLOB
CLOB should be used. |
Hibernate default mapping |
-
| |||||||||||
BYTEA |
Represents a byte array. For very long arrays, use BLOB. |
The maximum size is 2 GB, but the whole object is kept in |
memory when using this data type. The precision is a size |
constraint; only the actual data is persisted. For large text |
data BLOB or |
CLOB
CLOB should be used. |
Hibernate default mapping |
-
| |||||||||||
VARCHAR A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
-
-Hibernate default mapping |
| ||||||||||
LONGVARCHAR A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
-
-Hibernate default mapping |
| |||||||||||
VARCHAR2 A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
-
-Hibernate default mapping |
| |||||||||||
NVARCHAR A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
Hibernate default mapping |
-
| |||||||||||
NVARCHAR2 A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
Hibernate default mapping |
-
| |||||||||||
VARCHARCASESENSITIVE A Unicode String. Use two single quotes ('') to |
create a quote.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; |
only the actual data is persisted. The whole text is loaded into memory when using this |
data type. For large text data |
CLOB
should CLOB should be used; |
see there for details. |
-
-Hibernate default mapping |
| |||||||||||
VARCHARIGNORECASE Same |
VARCHAR
as VARCHAR, but not case sensitive when comparing. Stored in mixed case.The maximum precision |
is Integer.MAX_VALUE. The precision is a size constraint; only |
the actual data is persisted.The whole text is loaded |
into memory when using this data type. For large text data CLOB should be used; see there for details. |
Hibernate default mapping |
-
| |||||||||||
BLOB Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
TINYBLOB Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
MEDIUMBLOB Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
LONGBLOB Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
IMAGE Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
OID Like BINARY, |
but intended for very large values such as files |
or images. Unlike when using BINARY, large objects are not kept |
fully in-memory. |
Use PreparedStatement.setBinaryStream |
to store values.See also |
CLOB and Advanced / Large Objects. |
|
| ||||||||||||||||||||
CLOB CLOB is like VARCHAR, but intended for very large values. Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. Use PreparedStatment.setCharacterStream to store values. VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
| ||||||||||||||||||||
TINYTEXT CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
| ||||||||||||||||||||
TEXT CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
|
CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
| ||||||||||||||||||||
LONGTEXT CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
| ||||||||||||||||||||
NTEXT CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
| ||||||||||||||||||||
NCLOB CLOB is like VARCHAR, but intended for very large values. |
Unlike when using VARCHAR, large |
CLOB objects are not |
kept fully in-memory; instead, they are streamed. |
CLOB should be used for documents and texts with arbitrary size such as XML |
or HTML documents, text files, or memo fields of unlimited size. |
Use PreparedStatment.setCharacterStream to store values. |
VARCHAR should be used for text with relatively short average |
size (for example shorter than 200 characters). Short CLOB |
values are stored inline, but there is an overhead compared |
to VARCHAR. |
|
|