[support] Drupal 7 Schema API / datetime => char?

Tim Gustafson tjg at soe.ucsc.edu
Wed Jan 18 21:55:25 UTC 2012


> 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 at soe.ucsc.edu
Baskin School of Engineering                                     831-459-5354
UC Santa Cruz                                         Baskin Engineering 317B
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


More information about the support mailing list