Forum Moderators: open
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.