Hehe ... ellers tak. Jeg så ikke engang fejlen, men var bare optaget af besværet med at sortere skandinaviske bogstaver. Jeg har selv lige siddet og lavet en funktion i JavaScript, der kan. Det var sødt af dig nielle, men jeg springer over i denne omgang ;o)
<?php function doquery($con, $collating, $description) { print "$description:\n"; print "<ul>\n"; $query = mysql_query("SELECT f FROM t ORDER BY f $collating") or die(mysql_error()); while($row = mysql_fetch_array($query)) { print "<li>" . $row['f'] . "</li>\n"; } print "</ul>\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); ?>
Default on my system: 1 2 3 A a b B c C Å å æ Æ Ø ø Explicit general: 1 2 3 A a å Å æ Æ B b C c Ø ø Explicit danish: 1 2 3 A a b B c C æ Æ Ø ø Å å Explicit binary: 1 2 3 A B C a b c Å Æ Ø å æ ø
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.