| Subject | RE: [firebird-support] Re: How to change collattion of a field without droping and recreating it? - Email found in subject |
|---|---|
| Author | Leyne, Sean |
| Post date | 2010-08-24T01:00:41Z |
> > Or use the officially supported way - ALTER TABLE commands.Yes, you would create separate domain for each varchar length, but in reality you should have a "library" of varchar domains, and apply them in general usage [in most cases you don't need a VarChar(26) if you have a VarChar(30)]
> > You do not have to write them by hand, just generated them by reading
> system tables.
>
> I will have a look at this solution. Thank you.
> I will have to create several domains, one for each different varchar length.
> Am I right? If yes, is there a way to do that without using domains?
Sean