ERROR 1071 (42000): Specified key was too long; max key length is 767
bytes

ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)

I am using MySQL 5.1.31-community.  I first created a schema called
esoe and executed with root.

Has anyone seen this before?

Hi,

I have seen this before, though a long time ago.

Try dropping your database and creating it again with the "latin1" character
set, i.e.:
CREATE DATABASE esoe CHARACTER SET latin1;

After this, the creation script should work properly. The problem I had was
with the maximum width of a field that can be indexed by MySQL, since
Unicode is (sometimes) stored in more than 1 byte.

Hope that helps!

Shaun

2009/4/4 hodg...@gmail.com <hodg...@gmail.com>