clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805483 fiddles created (40795 in the last week).

CREATE TABLE test1 (txt VARCHAR(4) COLLATE 'latin1_general_ci') SELECT 'Test' txt UNION ALL SELECT 'TEST' UNION ALL SELECT 'tEsT';
 hidden batch(es)


CREATE TABLE test2 (txt VARCHAR(4) COLLATE 'latin1_general_cs') SELECT 'Test' txt UNION ALL SELECT 'TEST' UNION ALL SELECT 'tEsT';
 hidden batch(es)


SELECT COUNT(DISTINCT txt) FROM test1;
COUNT(DISTINCT txt)
1
 hidden batch(es)


SELECT COUNT(DISTINCT txt) FROM test2;
COUNT(DISTINCT txt)
3
 hidden batch(es)