Forum Moderators: open

Message Too Old, No Replies

MATCH gives odd results with currency symbols

trouble with $100, £100 and €100

         

scarything

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

10+ 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.