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]



Reply via email to