FullText Search 3.23.49-nt

2002-05-02 Thread Jan Peuker
Good evening List, I have a problem on my fulltext-search. If I create the sample table from MySQL-Doc it runs perfect. If I create my own - it doesn't. I can't say more: Here is my dump: CREATE TABLE tcl (id int(10) primary key not null, description varchar(254), date timestamp, value int(11),

RE: FullText Search 3.23.49-nt

2002-05-02 Thread Christopher Book
Try not using the word 'text' as your column name. Using reserved and key words causes problems. Chris sql CREATE TABLE tcl (id int(10) primary key not null, description varchar(254), date timestamp, value int(11), department tinyint(3), text text, fulltext(description,text))

Re: FullText Search 3.23.49-nt

2002-05-02 Thread Jeff Kilbride
- Original Message - From: Jan Peuker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 10:24 AM Subject: FullText Search 3.23.49-nt Good evening List, I have a problem on my fulltext-search. If I create the sample table from MySQL-Doc it runs perfect. If I create