Supported Data Types

OrientDB supports several data types natively. Below is the complete table.

#id Type SQL type Description Java type Minimum
Maximum
Auto-conversion from/to
0 Boolean BOOLEAN Handles only the values True or False java.lang.Boolean or boolean 0
1
String
1 Integer INTEGER 32-bit signed Integers java.lang.Integer or int -2,147,483,648
+2,147,483,647
Any Number, String
2 Short SHORT Small 16-bit signed integers java.lang.Short or short -32,768
32,767
Any Number, String
3 Long LONG Big 64-bit signed integers java.lang.Long or long -263
+263-1
Any Number, String
4 Float FLOAT Decimal numbers java.lang.Float or float 2-149
(2-2-23)*2127
Any Number, String
5 Double DOUBLE Decimal numbers with high precision java.lang.Double or double 2-1074
(2-2-52)*21023
Any Number, String
6 Datetime DATETIME Any date with the precision up to milliseconds. To know more about it, look at Managing Dates java.util.Date -
1002020303
Date, Long, String
7 String STRING Any string as alphanumeric sequence of chars java.lang.String -
-
-
8 Binary BINARY Can contain any value as byte array byte[] 0
2,147,483,647
String
9 Embedded EMBEDDED The Record is contained inside the owner. The contained Record has no Record ID ORecord -
-
ORecord
10 Embedded list EMBEDDEDLIST The Records are contained inside the owner. The contained records have no Record ID's and are reachable only by navigating the owner record List<Object> 0
41,000,000 items
String
11 Embedded set EMBEDDEDSET The Records are contained inside the owner. The contained Records have no Record ID and are reachable only by navigating the owner record Set<Object> 0
41,000,000 items
String
12 Embedded map EMBEDDEDMAP The Records are contained inside the owner as values of the entries, while the keys can only be Strings. The contained ords e no Record IDs and are reachable only by navigating the owner Record Map<String, ORecord> 0
41,000,000 items
Collection<? extends ORecord<?>>, String
13 Link LINK Link to another Record. It's a common one-to-one relationship ORID, <? extends ORecord> 1:-1
32767:2^63-1
String
14 Link list LINKLIST Links to other Records. It's a common one-to-many relationship where only the Record IDs are stored List<? extends ORecord 0
41,000,000 items
String
15 Link set LINKSET Links to other Records. It's a common one-to-many relationship Set<? extends ORecord> 0
41,000,000 items
Collection<? extends ORecord>, String
16 Link map LINKMAP Links to other Records as value of the entries, while keys can only be Strings. It's a common One-to-Many Relationship. Only the Record IDs are stored Map<String,    ? extends Record> 0
41,000,000 items
String
17 Byte BYTE Single byte. Useful to store small 8-bit signed integers java.lang.Byte or byte -128
+127
Any Number, String
18 Transient TRANSIENT Any value not stored on database
19 Date DATE Any date as year, month and day. To know more about it, look at Managing Dates java.util.Date -- Date, Long, String
20 Custom CUSTOM used to store a custom type providing the marshall and unmarshall methods OSerializableStream 0
X
-
21 Decimal DECIMAL Decimal numbers without rounding java.math.BigDecimal ?
?
Any Number, String
22 LinkBag LINKBAG List of Record IDs as spec RidBag ORidBag ?
?
-
23 Any ANY Not determinated type, used to specify Collections of mixed type, and null - - -

results matching ""

    No results matching ""