SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users ( nick text PRIMARY KEY, pass TEXT NOT NULL ); INSERT INTO users VALUES ( 'larry', md5(random()::text) ); INSERT INTO users VALUES ( 'Tom', md5(random()::text) ); INSERT INTO users VALUES ( 'tom', md5(random()::text) ); INSERT INTO users VALUES ( 'zena', md5(random()::text) ); INSERT INTO users VALUES ( 'Петя', md5(random()::text) ); INSERT INTO users VALUES ( 'Вася', md5(random()::text) ); INSERT INTO users VALUES ( 'вася', md5(random()::text) ); INSERT INTO users VALUES ( 'вова', md5(random()::text) ); select * from users order by nick COLLATE "default"; CREATE COLLATION "ru-cs" (provider = icu, locale = 'en-kc-false-kf-upper', deterministic=true); select * from users order by nick COLLATE "ru-cs"; select * from users order by lower(nick) COLLATE "default";