Re: FullText Search 3.23.49-nt

2002-05-02 Thread Jeff Kilbride
n. --jeff - 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 tab

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,tex

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),