-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 20 April 2004 15:47, jtsiy wrote:
> Dear fellow firebird users,
>
> Iam using FB 1.5, but Iam reading from the IB6 Manuals. The
> description of decimal and numeric doesn't seem to be clear to me. Can
> somebody help me with this?

If i'm not mistaken, NUMERIC will return an exact number of digits while
DECIMAL will return at least that number of digits.. So, NUMERIC(5,2) will
give you up to 99999.99 while DECIMAL(5,2) will give you 99999.99 or more..

> What am I going to use to a field that represent money? and field at
> represent quality in KILO unit?

I always keep my money in integer formats.. floating points are no good as you
may have rounding errors.. using either NUMERIC or DECIMAL would do just
fine..

> Thank you all
>

with metta,
Shawn Tan.

- --
========================= engineering elegance ========================
AESTE WORKS (M) SDN BHD
url: www.aeste.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAhN7k9KUEj/m6O5oRAkkgAJ43EeiVrDr70xd7unC7DpXCSA9W7gCfW8hB
Frhu+E8WG5mj/aX4pClQIq0=
=AAkF
-----END PGP SIGNATURE-----