I'm working on SELECT LIKE statement. How to make searching not dependend on national characters?
If I have pattern "theatre" the system should find columns containing "Theatre", "theatre" (thats easy ex. using "lower") but also "théâtre". Moreover I don't want to keep any own characters encoding table as I want to make my app to work with different languages.
And it should work in the opposite way, for "théâtre" as pattern, "Theatre", "theatre" and "théâtre" should be found.
Any solution?