Welcome to WebmasterWorld Guest from 54.197.94.141

Forum Moderators: open

Message Too Old, No Replies

MATCH gives odd results with currency symbols

trouble with $100, 100 and 100

   
3:17 pm on Oct 1, 2005 (gmt 0)

5+ Year Member



I am using a select MATCH on a FULLTEXT indices for full text searching but I am getting odd results.

My data contains different currency symbols and amounts e.g. $100, 100 and when I use the MATCH modifier in select query I get these odd results:

e.g. data contains 100 or 10

search for 100 works
search for 10 works
search for 100 fails

e.g. data contains 100 or 10

search for 100 works
search for 10 works
search for 100 fails

e.g. data contains $100 or $10

search for $100 fails
search for $10 fails
search for 100 works

in other words simply by searching for $ instead of a or gives totally different results. I am wondering if the $ symbol has some reserved MySQL use I am not aware of?

I am using MySQL 4.0.25-standard, my minimum search string length (ft_min_word_len) is 3 (so 10 works) and the table I am searching is UTF8 charset.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month