\n"; $query = mysql_query("SELECT f FROM t ORDER BY f $collating") or die(mysql_error()); while($row = mysql_fetch_array($query)) { print "

" . $row['f'] . "

\n"; } print "\n"; } $con = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("Test", $con) or die(mysql_error()); mysql_query("CREATE TABLE t (f VARCHAR(50))", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('A')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('B')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('C')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('a')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('b')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('c')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('1')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('2')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('3')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('Æ')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('Ø')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('Å')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('æ')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('ø')", $con) or die(mysql_error()); mysql_query("INSERT INTO t VALUES('å')", $con) or die(mysql_error()); doquery($con, "", "Default on my system"); doquery($con, "COLLATE LATIN1_GENERAL_CI", "Explicit general"); doquery($con, "COLLATE LATIN1_DANISH_CI", "Explicit danish"); doquery($con, "COLLATE LATIN1_BIN", "Explicit binary"); mysql_query("DROP TABLE t", $con) or die(mysql_error()); mysql_close($con); ?>