Re: Table Create Error 1071 (42000)
-> SE_DISPLAYID VARCHAR(100) unique,
-> ) ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;
ERROR 1071 (42000): Specified key was too long; max key length is 255 bytes
mysql> ERROR 1071 (42000)
Could it be the problem of the unique index on varchar(100) ?
varchar(100) with utf8 will need 300 bytes, exceeding 255 bytes as specified in the error message.
Subject
Views
Written By
Posted
7921
May 20, 2005 02:22PM
3022
May 20, 2005 02:37PM
2966
May 20, 2005 10:02PM
2647
May 23, 2005 09:51AM
2571
May 24, 2005 01:40AM
2485
May 25, 2005 10:49AM
Re: Table Create Error 1071 (42000)
6656
May 26, 2005 07:12PM
2798
June 02, 2005 09:14AM
2592
August 27, 2005 01:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.