clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (40569 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)