Subject RE: [firebird-support] Changing numeric domain to higher precsion
Author Bob Murdoch
Martijn,

I asked:
> Is there any problem with modifying this domain to something like,
> say, numeric(15,2)? I'm assuming that all of the tables
> with columns currently defined with domain will automatically
> be updated without problem?

and Martijn Tonies replied:
> If this is a Dialect 3 database, it's alright. For a dialect
> 1 database, however, the internal datatype will be a "double
> precision", which is a floating point datatype that can
> causes rounding errors.

Ah, that's a good point. This is a dialect 1 database. What's
the max precision I can go to before hitting the dreaded double
precision?

tia,

Bob M..