At 00:03 24/09/2008, you wrote:

>--- In firebird-support@yahoogroups.com, "max6395" <max6395@...> wrote:
>>
>> If i create a domain NUMERIC(15,6) in a FB 2.0 database (ODS 11.1)
>> firebird change the domain to NUMERIC(18,6).
>>
>> If i do the same with FB 1.5 the domain are created correctly.
>>
>> I have noticed this situation also if i convert to FB 2.0 a database
>> created with firebird 1.5 that contain this domain.
>>
>> Thanks!
>>
>> Massimo
>>
>
>Hi to All,
>there isn't anyone that have this problem ?

No, because it is not a problem at all. Firebird stores fixed numeric types (NUMERIC and DECIMAL) as either INTEGER (4 bytes) or BIGINT (8 bytes), depending on the declared precision. The scale is stored separately. So, if you are using a database tool that displays the *stored* scale and precision of the field, rather than the DECLARED scale and precision, you will see your precision-15 number as precision-18. Some tools, e.g., IB_SQL give you the means to display either the stored or the declared precision...

./heLen