When using http://doc.powerdns.com/generic-mypgsql-backends.html to create a database for pdns, all is going well until you add the part below 'To support or migrate to DNSSEC...'.
MySQL then complains:
#1071 - Specified key was too long; max key length is 1000 bytes
There are two keys in the index, both VARCHAR(255), for a total of 510 characters. I think the reason that MySQL complains is that one character can take up more than one byte on (for example) UTF8 collations. I'm not sure about that though.
Oh I'm sorry, forgot to mention that I'm using MySQL 5.1.30 currently, and will upgrade to a more recent 5.1.x or 5.5 in the near future.
I can confirm this issue and your reasoning; with the ('default') latin1 encoding, this does not happen. Making everything UTF8 causes this issue.
closed in 2400.