Subject Re: [firebird-support] differences between column types
Author Martijn Tonies
Hi Mike,

> I am converting a database file from ms-access to interbase. In the
> table editor for access, there is only one number type, called Number.
> However in Interbase there are several column types to choose from,
> including decimal, integer, numeric. What is the difference between
> them all? I couldnt find anything in the help system.

Integers are numerics without decimals. Numeric/Decimal is the
same in Firebird, both can be used to hold a precise numerical
value with decimals. Float/Double is used when you want an
approximate value.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions