Subject | Re: Fixing a varchar field |
---|---|
Author | eddressel |
Post date | 2009-04-03T16:44:24Z |
>First, it's a puzzle how the engine allowed you to reduce the sizeIf I report this--are you going to take the feature away :-0
>of a varchar column that contains data. If you can reproduce such
>an action, please post a Tracker entry with a reproducible case,
>remembering to include all the details of server version, platform,
>database ODS and database dialect.
How do I post a Tracker?
FB 1.5: I found out how to do this via IB Expert:
update RDB$RELATION_FIELDS
set RDB$FIELD_SOURCE = 'DM_STR30'
where (RDB$FIELD_NAME = '<Field Name>')
and (RDB$RELATION_NAME = '<TableName')
> Next...Thanks... FWIW, I wrote some Delphi code that changes the domain, trims the
strings to a max of 30 chars, then resets the domain.
Ed Dressel