homepage Welcome to WebmasterWorld Guest from 54.211.73.232
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MATCH gives odd results with currency symbols
trouble with $100, 100 and 100
scarything

5+ Year Member



 
Msg#: 65 posted 3:17 pm on Oct 1, 2005 (gmt 0)

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.

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved