'Body' column was converted from BLOB to TEXT as it shown in the
description.
How come the FULLTEXT still thinks it is a BLOB?
Please tell me if you know any work around. Thanks,
--Clemson
mysql> desc message1;
+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| Title | varchar(64) | | | | |
| Email | varchar(64) | YES | | NULL | |
| Created | datetime | YES | | NULL | |
| Body | text | YES | | NULL | |
+---------+-------------+------+-----+---------+----------------+
mysql> alter table message1 add FULLTEXT (Title,Body);
ERROR 1073: BLOB column 'Body' can't be used in key specification with the
used table type
-----Original Message-----
From: Clemson Chan [mailto:clemsonchan@stripped]
Sent: Friday, September 06, 2002 2:13 PM
To: Mysql
Cc: Clemson Chan
Subject: RE: FULLTEXT search questions
What is the following error? how do I fix it?
Thanks,
--Clemson
mysql> alter table message1 add FULLTEXT (Title,Body);
ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined
as NOT NULL
mysql> desc message1;
+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| Title | varchar(64) | YES | | NULL | |
| Email | varchar(64) | YES | | NULL | |
| Created | datetime | YES | | NULL | |
| Body | text | YES | | NULL | |
+---------+-------------+------+-----+---------+----------------+
-----Original Message-----
From: Clemson Chan [mailto:clemsonchan@stripped]
Sent: Friday, September 06, 2002 12:06 PM
To: Mysql
Subject: FULLTEXT search questions
Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.
The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be
created?
In my table, the 'body' column was define as BLOB, should I change it TEXT
before add the new FULLTEXT column? And what is the best to ALTER the column
from BLOB to TEXT without messing up the data.
Thanks a lot,
--Clemson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread118978@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-clemsonchan=earthlink.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread118993@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-rudy.metzger=pareto.nl@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
