Kevin Cowley wrote:
Running 4.1.4 with a database that has a default encoding of UTF8
If we execute the following we get an error. CREATE TABLE idxbe_resident ( urn INT UNSIGNED NOT NULL, keyAddress_Part1 CHAR(5) BINARY NOT NULL, dataPerson_Name CHAR(60), dataAddress_Part1 CHAR(140), dataAddress_Part2 CHAR(128), INDEX (keyAddress_Part1, dataPerson_Name, dataAddress_Part1, dataAddress_Part2, urn));
1071 (Specified key was too long; max key length is 1000 bytes) If we change the dataAddress_Part1 field to be 139 characters the error goes away.
Don'y know.
If we change it to be greater than 255 characters we get a different error 1170 (BLOB/TEXT column 'dataAddress_Part1' used in key specification without a key length)
VARCHAR() maximum length is 255. Greater than 255 is promoted to text.
Can I have an explanation or are these both bugs?
Kevin Cowley R&D
Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
