Re: FULL Text Limitation issue!

2003-09-25 Thread Imran Aziz
lt;[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 5:36 PM Subject: Re: FULL Text Limitation issue! > On 23 Sep 2003 at 17:07, Imran Aziz wrote: > > > I have come to know that mySQL FULL TEXT search has the limitation > > of the search phrase to be more then 3 chara

Re: FULL Text Limitation issue!

2003-09-23 Thread Paul DuBois
At 17:07 +0100 9/23/03, Imran Aziz wrote: Hello All, I have come to know that mySQL FULL TEXT search has the limitation of the search phrase to be more then 3 charators. In order to alter the default behavior one has to alter the variable ft_min_word_len. I am running MySQL 3.23.54 and t

Re: FULL Text Limitation issue!

2003-09-23 Thread Keith C. Ivey
On 23 Sep 2003 at 17:07, Imran Aziz wrote: > I have come to know that mySQL FULL TEXT search has the limitation > of the search phrase to be more then 3 charators. In order to > alter the default behavior one has to alter the variable > ft_min_word_len. I am running MySQL 3.23.54 a

FULL Text Limitation issue!

2003-09-23 Thread Imran Aziz
Hello All, I have come to know that mySQL FULL TEXT search has the limitation of the search phrase to be more then 3 charators. In order to alter the default behavior one has to alter the variable ft_min_word_len. I am running MySQL 3.23.54 and the FULL Text search works fine , but I am

Re: Full text limitation?

2003-01-10 Thread Sergei Golubchik
Hi! > > >SELECT count(a.rsori) pippo > > >FROM ecoras a, ecotxt b > > >WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE ) > > >AND a.rsori = b.rsori > > >AND a.rscod = b.rscod; > > > > If I execute a query like in the example, I don't obtain all rows where this > word is not present. Ins

Re: Full text limitation?

2003-01-09 Thread Walter Procopio
- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Walter Procopio" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 5:44 PM Subject: Re: Full text limitation? > At 14:03 +0100 1/8/03, Walter Procopio wr

Re: Full text limitation?

2003-01-08 Thread Paul DuBois
At 14:03 +0100 1/8/03, Walter Procopio wrote: Hi, I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional) linux server. I have tried many full text queries and I had only a problem with a query like this: SELECT count(a.rsori) pippo FROM ecoras a, ecotxt b WHERE MATCH ( b.rstxt

Full text limitation?

2003-01-08 Thread Walter Procopio
Hi, I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional) linux server. I have tried many full text queries and I had only a problem with a query like this: SELECT count(a.rsori) pippo FROM ecoras a, ecotxt b WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE ) AND a.rs

Re: Text Limitation

2002-03-15 Thread Thomas Spahni
n Mar 13, Thomas Spahni wrote: > > On Tue, 12 Mar 2002, shaj wrote: > > > > > Can any one tell me what is the text limitation for mySQL?? > > > > TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) > > characters. > > > > LONGT

Re: Text Limitation

2002-03-13 Thread Sergei Golubchik
Hi! On Mar 13, Thomas Spahni wrote: > On Tue, 12 Mar 2002, shaj wrote: > > > Can any one tell me what is the text limitation for mySQL?? > > TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) > characters. > > LONGTEXT allows up to 4'294'96

Re: Text Limitation

2002-03-13 Thread Thomas Spahni
On Tue, 12 Mar 2002, shaj wrote: > Can any one tell me what is the text limitation for mySQL?? TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) characters. LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf for most applications. The

Text Limitation

2002-03-13 Thread Victoria Reznichenko
shaj, Tuesday, March 12, 2002, 3:12:18 PM, you wrote: s> Can any one tell me what is the text limitation for mySQL?? What do you mean "text limitation"? You can read about blob and text column types at: http://www.mysql.com/doc/B/L/BLOB.html Read also about storage re

Re: Text Limitation

2002-03-12 Thread denonymous
From: "shaj " <[EMAIL PROTECTED]> > Can any one tell me what is the text limitation for mySQL?? The limitation for the TEXT datatype? >From http://www.mysql.com/doc/B/L/BLOB.html: "The maximum size of a BLOB or TEXT object is determined by its type, but the lar

Text Limitation

2002-03-12 Thread shaj
Can any one tell me what is the text limitation for mySQL?? -- Shaj Miah Cheif Information Officer t. 718.599.7775 e. [EMAIL PROTECTED] www.Diversityforhire.Com The Space And Place For Work & Culture -- - Before posting, pl