aspose file tools*
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30776
    
157

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