Sunil,
in InnoDB, the maximum indexed column length is 767 bytes.
Osku is improving the error message:
http://bugs.mysql.com/bug.php?id=13315
Regards,
Heikki
Oracle/Innobase
----- Original Message -----
From: ""Sunil Vishwas"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, October 25, 2005 5:33 AM
Subject: ERROR 1005 (HY000): Can't create table
'.\testDataBase\#sql-ec4_c.frm' (errno: 139)
------_=_NextPart_001_01C5D90C.62DB5CF5
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
(I am using mysql-5.0.15-win32)
Why I am getting this error and is there any way I can fix it, or is it
a bug?
Between I don't get this error if I change the field size to 767 or
below:
=20
drop table Address;
CREATE TABLE `Address`=20
(
`RecId` CHAR(32) NOT NULL,=20
`WebAddress` VARCHAR(1000),=20
CONSTRAINT PKAddress PRIMARY KEY(RecId)
);
=20
CREATE INDEX AddressWebAddressWebAddress ON Address (WebAddress);
=20
------_=_NextPart_001_01C5D90C.62DB5CF5--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]