For both of them the first number is the precision which means the
number of digits, and the second is the scale or the number of digits
after the decimal point.

(5,2) 999.99
(3,2) 9.99

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of zaher dirkey
Sent: Tuesday, October 04, 2005 9:42 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: NUMERIC and DECIMAL

Can you get more explain how it fail.

before i put the first message, i understand that DECIMAL(3,2) mean we
have 3 digits before dot and 2 digits after, but NUMERIC(5,2) mean we
have 5 digits included the 2 digits after the dot that mean NUMERIC
(5,2) is like DECIMAL(3,2) is that true?






------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links