Types.md

search
keywords concepts types

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. To know more about it, look at Managing Dates	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 Record ID	ORecord	- -	ORecord
10	Embedded list	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	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	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 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 Record IDs 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 Record IDs 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. To know more about it, look at Managing Dates	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 Record IDs as spec RidBag	ORidBag	? ?	-
23	Any	Not determinated type, used to specify Collections of mixed type, and null	-	-	-