SQLite Forum

sqlite3 a.db

sqlite>attach 'b.db' as b;

sqlite>select t.s t1, (x.s collate binary) t2 from t inner join b.t x  on t.s=x.s where t1<>t2;

t1          t2
----------  ----------
sample      SAMPLE
sqlite>