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]