Hi, I am Giang, from Hanoi Cancer Registry. Since we are setting up a new database and a dictionary, we change the length of some variables, for example the address code up to 10 numbers as our national statistics recommended. It would help us when we want to linkage other data.
However, when entrying the information, we cannot save the record. A message showed that "A truncation error was encountered trying to shrink VARCHAR ''....." to length 6?"
As we do not have IT professional in our unit, could you please show us how to fix it?
Hi, I am Giang, from Hanoi Cancer Registry. Since we are setting up a new database and a dictionary, we change the length of some variables, for example the address code up to 10 numbers as our national statistics recommended. It would help us when we want to linkage other data.
However, when entrying the information, we cannot save the record. A message showed that "A truncation error was encountered trying to shrink VARCHAR ''....." to length 6?" As we do not have IT professional in our unit, could you please show us how to fix it?
Thank you! Giang