Bug 391156 landed today which enables unicode support for LIKE statements in mozStorage. Thanks goes out to Seth for helping me to get this well tested and working correctly. This feature was needed for places search, as well as download manager’s new search.
Next thing we need to do is to better optimize our LIKE implementation so that is runs faster.
2 replies on “Unicode LIKE support for mozStorage”
So what are the wildcard chars to be used with LIKE statement?
The same ones as default. _ is MATCH_ONE and % is MATCH_ALL