LIKE search problems...

[gilly914]

I have a table with names in it, and a form that searches that field...
using MySQL:
...WHERE Name LIKE '%<user input>%'

When I search a specific letter, a get a lot of names with that letter in them, and another name that doesn't include the specific letter...

Why does this happen???


All the names in the table are in hebrew, and the letter that I searached is in hebrew... Could this be related?

[bjswift]

I am no expert, but could it be that the ascii value for the hebrew letter you are searching on is the same as another ascii letter and pulling those results too?

I do not know hebrew, but I'm assuming it uses other characters than that what are standard to the english alphabet.

B.

[gilly914]

i don't think that sounds right...

I don't think it's possible for two letters in hebrew to take up the same ascii value...

[bjswift]

Oh, I was thinking a hebrew character was matching up with an english character..

Sorry I am not very much help.

B.

[gilly914]

thanks for trying...

seriously, you never know from where the solution will come...

10X, gilly914