On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] <firebird-support@yahoogroups.com> wrote:
> > > I have defined the following domain : > > CREATE DOMAIN CURRENCY AS decimal(9,2) > > I would like to alter it as the following : > > ALTER DOMAIN CURRENCY AS decimal(18,2) > > I have many fields in tables that depend on this domain and they > are filled with values. > > Will they be restructured in their internal representation ( from > INTEGER to BIGINT in dialect 3 ) with no harm for the stored data ? > > > Initially, only the domain and column definitions will change, creating new format versions for the tables affected. When you insert new records into those tables, the new records will have the new format. Old records will be changed in memory when you read them, so they appear to be in the new format. The stored format of existing records change when the records are modified. Good luck, Ann
