I amend my last comment: This is because mbmaxlen is 4 bytes instead of 3, not necessarily any char value.
So it checks for a 767 byte max primary key length, but since mbmaxlen is set to 4 bytes 4 x 200 = 800 bytes and it fails.
Any idea why mbmaxlen is at 4 bytes instead of 3?
I amend my last comment: This is because mbmaxlen is 4 bytes instead of 3, not necessarily any char value.
So it checks for a 767 byte max primary key length, but since mbmaxlen is set to 4 bytes 4 x 200 = 800 bytes and it fails.
Any idea why mbmaxlen is at 4 bytes instead of 3?