SQLite Forum

SQLDIFF not showing true differences
The intent of the sqldiff utility is to show the logical differences between
two database files.  But there is not logical difference between 'sample' and
'SAMPLE' if they are in a "COLLATE nocase" column.  SQLite considers them to
be the same value.  So sqldiff is doing the right thing by reporting them as
the same.  We had to add extra logic to sqldiff to make it work that way.
It is intentional.