Subject | RE: [firebird-support] Changing numeric domain to higher precsion |
---|---|
Author | Bob Murdoch |
Post date | 2005-02-21T16:16:22Z |
Martijn,
I asked:
the max precision I can go to before hitting the dreaded double
precision?
tia,
Bob M..
I asked:
> Is there any problem with modifying this domain to something like,and Martijn Tonies replied:
> say, numeric(15,2)? I'm assuming that all of the tables
> with columns currently defined with domain will automatically
> be updated without problem?
> If this is a Dialect 3 database, it's alright. For a dialectAh, that's a good point. This is a dialect 1 database. What's
> 1 database, however, the internal datatype will be a "double
> precision", which is a floating point datatype that can
> causes rounding errors.
the max precision I can go to before hitting the dreaded double
precision?
tia,
Bob M..