In article <5.2.0.9.2.20050205121322.073b3dc8@...>, Helen Borrie
wrote:

> Did you change the table's definition between the original restore and the
> second one? It can only be MATTYPE or ASPECT.

No changes to the entire database

> Maybe, since ASPECT is a char(8), it might be that an insert in between
> times, that applied the default, has caused it (guessing wildly...the
> default value has only 6 characters..., so it's recognised on restore as
> "truncated"...?)

So does a default need to use the entire width of the field?

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly