You've declared a CHAR with length of 20 and only have 19 characters in the default. The string length of CHAR is static and not variable as with VARCHAR.
Nope, that's not it.
For one thing, CHAR columns are not required to fill out all the character space they have allocated to them; I have countless other CHAR columns with max lengths of 255 characters and a default of an empty string, and that's no problem.
And anyhow, changing the column lengths to 19 does not make the error go away.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tim Gustafson tjg@soe.ucsc.edu Baskin School of Engineering 831-459-5354 UC Santa Cruz Baskin Engineering 317B -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-