Data Types

Table 1. Data Types
Conversion Table

MSSQL Ver Data Type Firebird MSSQL
definition and comments

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 -1038 -1
through 1038 -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 231
– 1 (2,147,483,647) bytes.

6.5

int

INTEGER

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

6.5

money

DECIMAL(18, 4)

Monetary data values from -263
(-922,337,203,685,477.5808) through 263 – 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 230
– 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 -215 (-32,768) through 215
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 231
– 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).

http://www.firebirdsql.org/manual/migration-mssql-data-types.html

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: