wood burning stoves 2.0*
The moose likes JDBC and the fly likes problem in creating table with FULLTEXT KEY index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in creating table with FULLTEXT KEY index" Watch "problem in creating table with FULLTEXT KEY index" New topic
Author

problem in creating table with FULLTEXT KEY index

S.R.K.Vivek Raju
Ranch Hand

Joined: Sep 23, 2004
Posts: 58
Hi all

I am using mysql-4.1.11-nt stable version, now when i try to create a table with the FULLTEXT KEY index it gives an error saying

ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes.

I am relatively new to MySQL could antone tell me what does this mean

The table am creating is as follows:--
CREATE TABLE `contact_us` (
`id` int(10) unsigned NOT NULL auto_increment,
`firstname` varchar(45) default NULL,
`lastname` varchar(45) default NULL,
`middleinitial` char(1) default NULL,
`id_group` int(10) unsigned NOT NULL default '0',
`address` varchar(100) default NULL,
`city` varchar(45) default NULL,
`state` varchar(45) default NULL,
`userstate` varchar(45) default NULL,
`country` varchar(45) default NULL,
`zipcode` varchar(45) default NULL,
`business_phone` varchar(45) default NULL,
`home_phone` varchar(45) default NULL,
`mobile_phone` varchar(45) default NULL,
`email` varchar(45) default NULL,
`alternate_email` varchar(45) default NULL,
`im` varchar(45) default NULL,
`alternate_im` varchar(45) default NULL,
`website` varchar(100) default NULL,
`voip` varchar(45) default NULL,
`education` varchar(100) default NULL,
`company` varchar(100) default NULL,
`hobbies` varchar(100) default NULL,
`other_tags` varchar(100) default NULL,
PRIMARY KEY (`id`),
KEY `idx_name` (`firstname`,`lastname`),
KEY `idx_group` (`id_group`),
KEY `idx_city` (`city`),
KEY `idx_country` (`country`),
FULLTEXT KEY `idx_address` (`address`),
FULLTEXT KEY `idx_education` (`education`),
FULLTEXT KEY `idx_company` (`company`),
FULLTEXT KEY `idx_hobbies` (`hobbies`),
FULLTEXT KEY `idx_other_tags` (`other_tags`)
)
*************************************************************************
If the FULLTEXT is removed it gets created.

Thanks

With Regards
S.R.K.Vivek Raju.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

Vivek,
According to the syntax reference, you just write "fulltext", rather than "fulltext key".


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in creating table with FULLTEXT KEY index
 
Similar Threads
Problem displaying report using JSP
Restore problem
Three problems with mysql...
JPA-Hibernate One-to-One Bidirectional Relationship issue
NPE