Database Data Types
The following table represents how OutSystems data types are mapped to the data types of the database being used.
| OutSystems | SQL Server / SQL Azure | Oracle | MySQL | Obs. |
|---|---|---|---|---|
| Text | nvarchar(<length>) if the length is less than or equal to 2000, NVarchar(max) otherwise. | VARCHAR2(<length>), if the length is less than or equal to 2000, CLOB otherwise. | VARCHAR(<length>), if the length is less than or equal to 2000, LONGTEXT otherwise. | |
| Integer | int If an attribute with this type is set to auto number, the IDENTITY attribute is added. | NUMBER(10) If an attribute with this type is set to auto number, a sequence is added. | INT(11) If an attribute with this type is set to auto number, the AUTO_INCREMENT attribute is added. | |
| Long Integer | bigint If an attribute with this type is set to auto number, the IDENTITY attribute is added. | NUMBER(20) If an attribute with this type is set to auto number, a sequence is added. | BIGINT(20) If an attribute with this type is set to auto number, the AUTO_INCREMENT attribute is added. | |
| Decimal | decimal() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. | NUMBER() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. | DECIMAL() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. | At runtime, when values are read from (or saved to) the database, the number of decimal digits depends on the application server. |
| Boolean | bit | NUMBER(1) | TINYINT(1) | |
| Date Time | datetime | TIMESTAMP | DATETIME() | |
| Date | datetime | TIMESTAMP | DATETIME() | Dates in OutSystems range from 1900-01-01 00:00:00 to 3000-12-31 23:59:59. |
| Time | datetime | TIMESTAMP | DATETIME() | |
| Phone Number | varchar(20) | VARCHAR2(20) | VARCHAR(20) | |
| varchar(250) | VARCHAR2(250) | VARCHAR(250) | ||
| Binary Data | image | BLOB | BLOB | |
| Currency | decimal(37,8) | NUMBER(37,8) | DECIMAL(37,8) | Entity Identifier |