schema does not work for all character sets

[donald]

buczek@theinternet:/scratch/local$ mysql --defaults-group-suffix=mxqtest -f < ~/git/mxq/mysql/create_tables.sql 
ERROR 1067 (42000) at line 1: Invalid default value for 'group_date_end'
ERROR 1074 (42000) at line 66: Column length too big for column 'job_argv' (max = 16383); use BLOB or TEXT instead
ERROR 1067 (42000) at line 133: Invalid default value for 'daemon_start'
buczek@theinternet:/scratch/local$ mysql --defaults-group-suffix=mxqtest -e 'show variables like "version";'
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| version       | 5.7.18 |
+---------------+--------+

[donald]

Nope. The difference was the default character set of the server and so the character set of the database created without an explicit character set. The running database has "latin1" the new database had "utf8nb4" where the limit for VARCHAR is 16383 characters.

When the database is created with CREATE DATABASE mxq DEFAULT CHARSET=latin1; the limit is 65535