0

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?

user2707175
  • 1,071
  • 2
  • 16
  • 42
  • that requires a *collation*. not supported in sqlite3 on android. – njzk2 Nov 12 '13 at 21:56
  • 1
    One approach in http://stackoverflow.com/questions/16282083/how-to-ignore-accent-in-sqlite-query-android/16283863#16283863 – laalto Nov 13 '13 at 08:52
  • @laalto - thank a lot, that's some kind of workaround but then database is definitely much bigger. Have you heard about any plans of adding new collate rules to Android sqlite3? – user2707175 Nov 13 '13 at 16:53
  • I was wondering if it's possible to do it in the opposite way. To keep data in the database as it is but to automatically modify pattern to add those accented characters. Ex. when typing e some java bult function add eééęë etc. and then the same in captials. Have you ever heard about function like that? – user2707175 Nov 13 '13 at 16:57

0 Answers0