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.
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)
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
**************************************************************************************
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must
not use, copy, disclose, otherwise disseminate or take any action based on
this e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception
and unauthorised amendment. Alchemetrics does not accept any liability for
any such corruption, interception, amendment or the consequences thereof.
**************************************************************************************
