[firebase-br] Migrar base de datos de mssql a firebird
Adriano Ferreira
aerreira68 em gmail.com
Sex Ago 14 19:50:22 -03 2009
Firebird supports two scaled datatypes, NUMERIC and DECIMAL, for handling numeric data with a fixed decimal point, such as monetary values. You can specify optional precision and scale factors for both datatypes:
a.. Precision is the total number or maximum number of digits, both significant and fractional, that can appear in a column of these datatypes. The allowable range for precision is from 1 to a maximum of 18.
b.. Scale is the number of digits to the right of the decimal point that comprise the fractional portion of the number. The allowable range for scale is from zero to precision; in other words, scale must be less than or equal to precision.
http://www.janus-software.com/fbmanual/manual.php?book=psql&topic=30
_
Adriano Ferreira
----- Original Message -----
From: André Barros
To: FireBase
Sent: Friday, August 14, 2009 12:03 PM
Subject: Re: [firebase-br] Migrar base de datos de mssql a firebird
eu busquei mas no caso deste campo especifico até agora nao encontrei nada
que me estabelece como colocar a precisao quando crio o campo decimal cuando
vou criar a tabela dá-me erro que a scale ten de estar entre o e a precision
Mais detalhes sobre a lista de discussão lista