SQLite Forum

SQLDIFF not showing true differences
Login
If a column has `collate nocase`, SQLDIFF utility fails to report any differences.

Database a.db:

```
CREATE TABLE t(s collate nocase);
INSERT INTO t VALUES('sample');
```

and database b.db:

```
CREATE TABLE t(s collate nocase);
INSERT INTO t VALUES('SAMPLE');
```

Now, use `SQLDIFF a.db b.db` and you won't see any differences.
This is because of the `collate nocase` as when you remove it, the difference is shown.

I don't know if this is intentional behavior but to me it appears wrong.
I expect a difference tool to show true differences between two databases.

The use of `collate nocase` may be used for case-insensitive retrieval but if the actual contents are different, a difference tool should report that.