Hello, all!
I have the table like this:
CREATE TABLE forum_fun_bodies (
id bigint(20) unsigned DEFAULT '0' NOT NULL,
body text DEFAULT '' NOT NULL,
thread int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY thread (thread)
);
And I want to create index:
ALTER TABLE forum_fun_bodies
ADD INDEX body_idx (body(100));
What I get is error message like:
ERROR 1073: BLOB column 'body' can't be used in key specification with the used table type
What's that? Why? I have already created a number of indexes for blobs without problems and I wonder if something is wrong in my statements.
Thanks for your help!
I have the table like this:
CREATE TABLE forum_fun_bodies (
id bigint(20) unsigned DEFAULT '0' NOT NULL,
body text DEFAULT '' NOT NULL,
thread int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY thread (thread)
);
And I want to create index:
ALTER TABLE forum_fun_bodies
ADD INDEX body_idx (body(100));
What I get is error message like:
ERROR 1073: BLOB column 'body' can't be used in key specification with the used table type
What's that? Why? I have already created a number of indexes for blobs without problems and I wonder if something is wrong in my statements.
Thanks for your help!