OrientDB Manual

Supported Types

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

#id Type Description Java type Minimum
Maximum		 Auto-conversion from/to
0 Boolean Handles only the values True or False java.lang.Boolean or boolean 0
1		 String
1 Integer 32-bit signed Integers java.lang.Integer or int -2,147,483,648
+2,147,483,647		 Any Number, String
2 Short Small 16-bit signed integers java.lang.Short or short -32,768
32,767		 Any Number, String
3 Long Big 64-bit signed integers java.lang.Long or long -263
+263-1		 Any Number, String
4 Float Decimal numbers java.lang.Float or float 2-149
(2-2-23)*2127		 Any Number, String
5 Double Decimal numbers with high precision java.lang.Double or double 2-1074
(2-2-52)*21023		 Any Number, String
6 Datetime Any date with the precision up to milliseconds java.util.Date -
1002020303		 Date, Long, String
7 String Any string as alphanumeric sequence of chars java.lang.String -
-		 -
8 Binary Can contain any value as byte array byte[] 0
2,147,483,647		 String
9 Embedded The Record is contained inside the owner. The contained Record has no RecordId ORecord -
-		 ORecord
10 Embedded list The Records are contained inside the owner. The contained records have no RecordIds and are reachable only by navigating the owner record List<Object> 0
41,000,000 items		 String
11 Embedded set The Records are contained inside the owner. The contained Records have no RecordId and are reachable only by navigating the owner record Set<Object> 0
41,000,000 items		 String
12 Embedded map The Records are contained inside the owner as values of the entries, while the keys can only be Strings. The contained ords e no RecordIds and are reachable only by navigating the owner Record Map<String, ORecord> 0
41,000,000 items		 Collection<? extends ORecord<?>>, String
13 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 Links to other Records. It's a common one-to-many relationship where only the RecordIds are stored List<? extends ORecord 0
41,000,000 items		 String
15 Link set 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 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 RecordIds are stored Map<String,
    ? extends Record>		 0
41,000,000 items		 String
17 Byte Single byte. Useful to store small 8-bit signed integers java.lang.Byte or byte -128
+127		 Any Number, String
18 Transient Any value not stored on database
19 Date Any date as year, month and day java.util.Date -- Date, Long, String
20 Custom used to store a custom type providing the marshall and unmarshall methods OSerializableStream 0
X		 -
21 Decimal Decimal numbers without rounding java.math.BigDecimal ?
?		 Any Number, String
22 LinkBag List of RecordIds as spec RidBag ORidBag ?
?		 -
23 Any Not determinated type, used to specify Collections of mixed type, and null - - -