[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