At 07:59 AM 12/14/2004, Storage Box wrote:

>Sure, I was just curious if Firebird had a "money"-like value or if there
>was some way to pull this off (without using a character type). I'm coming
>from the sql server world where there is such a type that does in fact store
>trailing zeroes.

numeric (12,2) stores the value as a 64 bit integer and passes the
scale around as a part of the description of the value. If you
store 123.10 as numeric (12,2), the value in the database is 12310
or 0x3016. The scale is used in comparisons and computations so
the value behaves correctly.

Regards


Ann