FireBird DataType

6.5

bigint

INT64

8-byte integer type.

6.5

binary

CHAR

Fixed-length binary data with a maximum length of 8,000 bytes. In 6.5, maximum was 255.

6.5

bit

CHAR(1)

Integer data with either a 1 or 0 value. Typically, replaced by constants 'T' and 'F'.

6.5

char

CHAR

Fixed-length non-Unicode character data with a maximum length of 8,000 characters. In 6.5, maximum was 255. Firebird can hold up to 32,767 characters.

6.5

cursor

A reference to a cursor. This can only be used inside stored procedure or triggers; it cannot be used on table declarations.

6.5

datetime

TIMESTAMP

Date and time data from January 1, 1753, to December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.

6.5

decimal

DECIMAL

Fixed precision and scale numeric data from -10³⁸ -1 through 10³⁸ -1.

6.5

float

FLOAT

Floating precision number data from -1.79E + 308 through 1.79E + 308.

6.5

image

BLOB

Variable-length binary data with a maximum length of 2³¹ - 1 (2,147,483,647) bytes.

6.5

int

INTEGER

Integer (whole number) data from -2³¹ (-2,147,483,648) through 2³¹ - 1 (2,147,483,647).

6.5

money

DECIMAL(18, 4)

Monetary data values from -2⁶³ (-922,337,203,685,477.5808) through 2⁶³ - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.

7

nchar

CHAR(x) CHARACTER SET UNICODE_FSS

Fixed-length Unicode data with a maximum length of 4,000 characters.

7

ntext

BLOB SUB_TYPE TEXT

Variable-length Unicode data with a maximum length of 2³⁰ - 1 (1,073,741,823) characters.

6.5

numeric

NUMERIC

In MS SQL, decimal and numeric are synonims.

7

nvarchar

VARCHAR(x) CHARACTER SET UNICODE_FSS

Fixed-length Unicode data with a maximum length of 4,000 characters.

6.5

real

DOUBLE

Floating precision number data from -3.40E + 38 through 3.40E + 38.

6.5

smalldatetime

TIMESTAMP

Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. Firebird's has greater range and accuracy.

6.5

smallint

SMALLINT

Integer data from -2¹⁵ (-32,768) through 2¹⁵ - 1 (32,767).

6.5

smallmoney

DECIMAL(10, 4)

Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. Note that Firebird's range is greater with this declaration.

2000

sql_variant

BLOB

Allows the storage of data values of different data types.

2000

table

none

Stores results temporarily for later user.

6.5

text

BLOB SUB_TYPE TEXT

Variable-length non-Unicode data with a maximum length of 2³¹ - 1 (2,147,483,647) characters.

6.5

timestamp

INTEGER

A database-wide unique number. In Firebird, you will have to manage uniqueness through generators.

6.5

tinyint

SMALLINT

Integer data from 0 through 255. Firebird does not have such a small data type.

6.5

varbinary

CHAR

Variable-length binary data with a maximum length of 8,000 bytes.

6.5

varchar

VARCHAR

Variable-length non-Unicode data with a maximum of 8,000 characters. Firebird can hold up to 32,765 characters. In 6.5, maximum was 255.

7

uniqueidentifier

CHAR(38)

A globally unique identifier (GUID). In Firebird, you will have to generate the values with User-Defined Functions (UDFs).