Archive for February, 2007

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 [...]