[TIMOB-16144] iOS: SQLite doesn't support LIKE for non ASCII chars

GitHub Issue	n/a
Type	New Feature
Priority	Low
Status	Open
Resolution	Unresolved
Affected Version/s	Release 3.2.0
Fix Version/s	n/a
Components	iOS
Labels	SupportTeam
Reporter	Mauro Parra-Miranda
Assignee	Unknown
Created	2014-01-08T01:00:58.000+0000
Updated	2018-02-28T20:03:15.000+0000

Description

Problem Description

The user needs to search in SQLite for a string like ängs, his SQLite contains the word Ängs, which should be a match, since he used LIKE. In the iOS simulator, he gets 0 rows as result.

Workaround

Right now we requested him to search for ängs and Ängs in order to find the matches.

Extra info

From this item: http://stackoverflow.com/questions/10356062/how-to-deal-with-accented-characters-in-ios-sqlite appears that the LIKE function can be overwritten in order to support upper/lower case queries in non ASCII chars.

Community issue

http://developer.appcelerator.com/question/161275/sqlite-query-with-

Comments

Ingo Muschenetz 2014-01-08

This is not native functionality, so moving to a feature request. From what I understand, we would implement option #2 from the top answer in the StackOverflow post, and effectively allow for a new "unaccented" SQL function users could take advantage of. Is that correct?

JSON Source