Reported By: Jose Eduardo Helminsky Reported On: 2/14/2005 For: Version 4.17 Build 1
# 1978RepairTable Does Not Correct Invalid Default Values for BLOB Columns I've found a problem with a table. The problem occurs when I need to alter structure or apply optimizetable then I receive an #8963 error. The only solution I've found was clear all values in this column and try it again. RepairTable should fix this problem.
CommentsThe problem was caused by a value of 0 set as the default value for a BLOB column. DBISAM no longer permits this and the repair functionality will fix it if it finds it.
ResolutionFixed Problem on 2/16/2005 in version 4.18 build 1