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

[Earnie Boyd]

On Wed, Jan 18, 2012 at 2:38 PM, Tim Gustafson wrote:
> Doh!  Sorry about that; I incorrectly anonymized the error message.  It should have said:
>
> Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'column_2': ALTER TABLE {foo} CHANGE `column_1` `column_1` CHAR(20) NOT NULL DEFAULT '0000-00-00 00:00:00'; Array ( ) in db_change_field() (line 2984 of includes/database/database.inc).


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.

-- 
Earnie
-- https://sites.google.com/site/earnieboyd