Data being lost when attribute size changed

denisv · Post by **denisv** » Wed Aug 30, 2006 12:01 pm

I was under the impression that naturally existing data in an attribute will be lost if you change the attribute type or make it smaller.

Should it not be the case that if you increase the size of the attribute while not changing the type that the data should be retained ?

I changed the size of an attribute from 500 - 2000. While I did get the warning of data loss, I was in test and proceeded. All data in that attribute was lost.

If this is the case it coudl have significant impact on distributing BS's where a request has come in to increase a field length.

aware_support2 · Post by **aware_support2** » Wed Aug 30, 2006 1:32 pm

Which database are you using?

denisv · Post by **denisv** » Wed Aug 30, 2006 2:20 pm

MSSQL 2000
Aware V2 B870

aware_support · Post by **aware_support** » Wed Aug 30, 2006 3:46 pm

For SQL Server the data will not be lost only if new length is less than 1000. For greater lengths a different column type is created which cannot preserve data in the old column type.

This is SQL Server limitation

denisv · Post by **denisv** » Wed Aug 30, 2006 5:02 pm

Ok, good to know.

Thanks

DV