On 4 Apr 2016, at 10:47am, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote:
> It would be a gross mistake if the databases weren't the same. > > It's an existing and populated database. The only thing that comes to mind is that one app is using case sensitive and the other is not. Unfortunately the command to check the status seems to be missing from the documentation and therefore possibly missing from SQLite. In both apps, before executing select * from companies where post_code like 'rg%' execute PRAGMA case_sensitive_like = ON and see what happens. Then perhaps try it off. <https://www.sqlite.org/pragma.html#pragma_case_sensitive_like> Simon.
