Thread: JDBC and numeric datatype...

JDBC and numeric datatype...

From
"Scott Muir"
Date:
Can someone suggest the correct way of dealing with the NUMERIC data type
through JDBC?  The attribute in question is a NUMERIC(10,2) (currency)...
We're thinking of just using a float to handle it...  Since this type can be
much larger than we're using, what should be used in those cases???

Thanks.
S.



Re: JDBC and numeric datatype...

From
Jan Wieck
Date:
Scott Muir wrote:
> Can someone suggest the correct way of dealing with the NUMERIC data type
> through JDBC?  The attribute in question is a NUMERIC(10,2) (currency)...
> We're thinking of just using a float to handle it...  Since this type can be
> much larger than we're using, what should be used in those cases???
   Look  for  some arbitrary precision math library to deal with   it. NUMERIC in PostgreSQL is an exact numeric  data
type, a   strict  requirement  when  dealing  with  monetary  values in   bookkeeping systems. A single conversion  to
and back  from   floating point violates this requirement already.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com