Hi people, Im writing a search script where a string typed into a text field is looked for in the database.
I have a problem with character sets.
Lets say a user searches for a word with þ in it, or ý, I want to be able to bring results with that, as well as with s and i.
SO say a user types: þami
I want it to bring back entries from the DB like samýa, þamýw etc. I just can't work out how I do this, I could use a replace function to creat a new string replacing s with þ, þ with s etc and submit multiple queries but this seems very complicated and wasteful of resources, is there an easier way?
Thanks.
