| Subject: | key VARCHAR( 600 ) too long for MySQL using UTF-8 charset |
Trying to have CHI::Driver::DBI create its own table on a MySQL database where the default
charset is UTF-8 give this error:
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Changing the charset to Latin1 for the table makes the key length succeed:
CREATE TABLE IF NOT EXISTS chi_Default ( `key` VARCHAR(600), `value` TEXT, PRIMARY KEY (
`key` ) ) CHARSET=LATIN1;
I don't know if this is a bug you want to actually "fix", or if you just want to make a note of it in
the docs. Probably the latter.