I didn't find anything good on that topic. Im currently implementing simple search function with will use LIKE to find requested records. But I wan't to make "accents-free" search.
For example: object name is: "Gdańsk", it should be found by string "Gdansk" and "Gdańsk".
If it was the other way around, it would be as simple as transforming search string, but since we have to transform the original value before comparision then it's little more diffcult.
Any help would be welcome.
Im using MySQL 5.5.