Subject | Re: [firebird-support] Alter a Varchar size |
---|---|
Author | Ivan Prenosil |
Post date | 2004-08-24T11:35:07Z |
> If I change a varchar size from 15 to 11, for example, andIt is not possible using standard DDL commands
> thereĀ“re some rows containing up to 15 positions,
> what happens with this ones?
to shrink field size (only create new column and copy data over)
However, you can do it by updating system tables.
> Do I have to cut the extre chars?Yes, first cut extra chars, then mess with system tables.
(Otherwise cells with too long data become unreadable.)
Ivan