-- Collection of code snippets by Arne VajhÃ¸j 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE demo (
   id INTEGER NOT NULL PRIMARY KEY,
   s VARCHAR(50)
) DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;

INSERT INTO demo VALUES (1, 'A');
INSERT INTO demo VALUES (2, 'B');
INSERT INTO demo VALUES (3, 'C');
INSERT INTO demo VALUES (4, '1');
INSERT INTO demo VALUES (5, '2');
INSERT INTO demo VALUES (6, '3');
INSERT INTO demo VALUES (7, 'Æ');
INSERT INTO demo VALUES (8, 'Ø');
INSERT INTO demo VALUES (9, 'Å');
INSERT INTO demo VALUES (10, 'E');
INSERT INTO demo VALUES (11, 'É');
INSERT INTO demo VALUES (12, 'È');

SELECT * FROM demo ORDER BY s;

DROP TABLE demo;

CREATE TABLE demo (
   id INTEGER NOT NULL PRIMARY KEY,
   s VARCHAR(50)
) DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;

INSERT INTO demo VALUES (1, 'A');
INSERT INTO demo VALUES (2, 'B');
INSERT INTO demo VALUES (3, 'C');
INSERT INTO demo VALUES (4, '1');
INSERT INTO demo VALUES (5, '2');
INSERT INTO demo VALUES (6, '3');
INSERT INTO demo VALUES (7, 'Æ');
INSERT INTO demo VALUES (8, 'Ø');
INSERT INTO demo VALUES (9, 'Å');
INSERT INTO demo VALUES (10, 'E');
INSERT INTO demo VALUES (11, 'É');
INSERT INTO demo VALUES (12, 'È');

SELECT * FROM demo ORDER BY s;

DROP TABLE demo;

CREATE TABLE demo (
   id INTEGER NOT NULL PRIMARY KEY,
   s VARCHAR(50)
) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci;

INSERT INTO demo VALUES (1, 'A');
INSERT INTO demo VALUES (2, 'B');
INSERT INTO demo VALUES (3, 'C');
INSERT INTO demo VALUES (4, '1');
INSERT INTO demo VALUES (5, '2');
INSERT INTO demo VALUES (6, '3');
INSERT INTO demo VALUES (7, 'Æ');
INSERT INTO demo VALUES (8, 'Ø');
INSERT INTO demo VALUES (9, 'Å');
INSERT INTO demo VALUES (10, 'E');
INSERT INTO demo VALUES (11, 'É');
INSERT INTO demo VALUES (12, 'È');

SELECT * FROM demo ORDER BY s;

DROP TABLE demo;
