Data types of attributes in the DBMS

DBMS /

GeneXusDataType

SQL Server

PostgreSQL

MySQL

Informix

DB2 for iSeries

Oracle

DB2 Universal Database

SQLite

Character(n)

CHAR(n)

CHAR(n)

CHAR(n)

CHAR(n)

CHAR(n)

CHAR(n)

CHAR(n)

WHEN n <= 253

TEXT COLLATE RTRIM

VARCHAR(n)

WHEN n > 254

Character(n)

WHEN Enable NLS=True

NCHAR(n)

CHAR(n)

NLS not implemented

NATIONAL CHAR(n)

CHAR(n)

NLS not implemented

GRAPHIC(n) CCSID 13488

NCHAR(n)⁽⁴⁾

GRAPHIC(n)

n < 128

TEXT COLLATE RTRIM

VARGRAPHIC(n)

WHEN n >= 128

Boolean

BIT

BOOLEAN

BOOL

BOOLEAN

DECIMAL(1)

NUMERIC(1)

NUMERIC(1)

INTEGER

Blob

VARBINARY(MAX)

WHEN Version >= 2005

BYTE

LONGBLOB

BYTE

BLOB

BLOB

BLOB(2G) NOT LOGGED

TEXT

IMAGE

WHEN Version < 2005

Date

DATETIME

DATE

DATE

DATETIME Year to Day

CHAR(8)

DATE

DATE

TEXT

DateTime

DATETIME

TIMESTAMP without time zone

DATETIME

DATETIME Year to Second

TIMESTAMP

DATE

TIMESTAMP

TEXT

GUID

UNIQUEIDENTIFIER

CHAR(36)

CHAR(36)

CHAR(36)

CHAR(36)

CHAR(36)

CHAR(36)

CHAR(36)

VarChar(n)

VARCHAR(n)

VARCHAR(n)

VARCHAR(n)

VARCHAR(n)

VARCHAR(n)

VARCHAR(n)⁽⁵⁾

VARCHAR(n)

TEXT COLLATE RTRIM

VARCHAR(n, a)

VARCHAR2(n)

WHEN Declare Varchar as Varchar2 = True

VARCHAR2(n)

WHEN Declare Varchar as Varchar2 = True

VarChar(n)

WHEN Enable NLS=True

NVARCHAR(n)

VARCHAR(n)

NLS not implemented

NATIONAL VARCHAR(n)

VARCHAR(n)

VARCHAR(n)(1)

VARGRAPHIC(X) CCSID 13488(2)

VARCHAR(n)⁽⁵⁾

VARGRAPHIC(n)

TEXT COLLATE RTRIM

VARCHAR(n, a)

NLS not implemented

NVARCHAR2(n)

WHEN Declare Varchar as Varchar2 = True

NVARCHAR2(n)⁽⁶⁾

WHEN Declare Varchar as Varchar2 = True

LongVarChar(n)

VARCHAR(MAX)

WHEN Version >= 2005

TEXT

TEXT

WHEN n < 65535

TEXT

CLOB

CLOB

CLOB(n)

TEXT COLLATE RTRIM

TEXT

WHEN Version < 2005

MEDIUMTEXT

WHEN 65535 >= n

AND n < 16777215

LONGTEXT

WHEN n >= 16777215

LongVarChar(n)

WHEN Enable NLS=True

NVARCHAR(MAX)

WHEN Version >= 2005

TEXT

TEXT CHARACTER SET utf8

WHEN n < 65535

TEXT

CLOB(1)

DBCLOB CCSID 13488(2)

CLOB

DBCLOB(n)

TEXT COLLATE RTRIM

NTEXT

WHEN Version < 2005

MEDIUMTEXT CHARACTER SET utf8

WHEN 65535 >= n

AND n < 16777215

LONGTEXT CHARACTER SET utf8

WHEN n >= 16777215

Numeric(L.0)

SMALLINT

WHEN L < 5

SMALLINT

WHEN L < 5

SMALLINT

WHEN L < 5

SERIAL(s)

WHEN L < 5

AND Autonumber = True

DECIMAL(L)

NUMBER(L)

NUMBER(L)

NUMERIC(L)

INTEGER WHEN L < 19

INT

WHEN 5 >= L < 10

INTEGER

WHEN 5 >= L < 10

MEDIUMINT

WHEN 5 >= L < 7

SERIAL8(s)

WHEN 5 >= L < 10

AND Autonumber = True

NUMERIC WHEN L >= 19

DECIMAL(L)

WHEN L >= 10

BIGINT

WHEN 10 >= L < 19

INT

WHEN 7 >= L < 10

INT

WHEN L < 5

AND Subtype of

Autonumber = True

NUMERIC(L)

WHEN L >= 19

BIGINT

WHEN 10 >= L < 19

INT8

WHEN 5 >= L < 10

AND Subtypeof

Autonumber = True

NUMERIC(L)

WHEN L >= 19

SMALLINT

WHEN L < 5

ANDAutonumber = False

INT

WHEN 5 >= L < 10

AND Autonumber = False

DECIMAL(L)

WHEN L >= 10

Numeric(L.D)

SMALLMONEY

WHEN 0 < D < 4

AND L-D-1 < 6

NUMERIC(L-1,D)

NUMERIC(L-1,D)

DECIMAL(L-1,D)

DECIMAL(L-1,D)

NUMBER(L-1,D)

NUMBER(L-1,D)

NUMERIC(L-1,D)

NUMERIC

MONEY

WHEN 0 < D < 4

AND 6 >= L-D-1 < 15

DECIMAL(L-1,D)

WHEN D >= 4

OR L-D-1 >= 15