DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6).
Are you sure? I can store such value both in (15, 4) as well in (15, 6). The range of accepted values for (15, 6) and (17, 6) is the same: -9223.372.036.854,775808 to 9223.372.036.854,775807 []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br DY> 10.08.2017 20:29, Carlos H. Cantu wrote: >> >> Can someone explain why I can't change a field from numeric (15,4) to >> numeric (15,6) [error is "New scale specified for column TESTE must be >> at most 4."], but can change it to numeric (17,6) ? DY> Because (15, 6) provides less integral precision (9 digits instead of DY> 11) and theoretically some existing values may not fit, making those DY> records unreadable. DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6). DY> Dmitry DY> ------------------------------------------------------------------------------ DY> Check out the vibrant tech community on one of the world's most DY> engaging tech sites, Slashdot.org! http://sdm.link/slashdot DY> Firebird-Devel mailing list, web interface at DY> https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
