Danish alphabetization requires abc... to come before æ, ø and å. In my MySQL database, when I sort alphabetically, it comes out as
Øresund
Åse
Alfa
which is strange.
Server connection collation is utf8_general_ci
Database collation is latin1_swedish_ci
Table collation is utf8_danish_ci
Column collation is utf8_danish_ci
Shouldn't setting a collation on the table/column overwrite collations on a higher level?
My website is all UTF8, and when I input text from the website, it comes fine ourout again. But when I look at the text in phpmyadmin, characters are displayed wrongly.
I've pasted the contents of the file, editschool.php, here: http://pastebin.com/pv8u0BDj
Danish alphabetization requires abc... to come before æ, ø and å. In my MySQL database, when I sort alphabetically, it comes out as
Øresund
Åse
Alfa
which is strange.
Server connection collation is utf8_general_ci
Database collation is latin1_swedish_ci
Table collation is utf8_danish_ci
Column collation is utf8_danish_ci
Shouldn't setting a collation on the table/column overwrite collations on a higher level?
My website is all UTF8, and when I input text from the website, it comes fine our again. But when I look at the text in phpmyadmin, characters are displayed wrongly.
Danish alphabetization requires abc... to come before æ, ø and å. In my MySQL database, when I sort alphabetically, it comes out as
Øresund
Åse
Alfa
which is strange.
Server connection collation is utf8_general_ci
Database collation is latin1_swedish_ci
Table collation is utf8_danish_ci
Column collation is utf8_danish_ci
Shouldn't setting a collation on the table/column overwrite collations on a higher level?
My website is all UTF8, and when I input text from the website, it comes fine out again. But when I look at the text in phpmyadmin, characters are displayed wrongly.
I've pasted the contents of the file, editschool.php, here: http://pastebin.com/pv8u0BDj
MySQL sorting wrongly with danish characters
Danish alphabetization requires abc... to come before æ, ø and å. In my MySQL database, when I sort alphabetically, it comes out as
Øresund
Åse
Alfa
which is strange.
Server connection collation is utf8_general_ci
Database collation is latin1_swedish_ci
Table collation is utf8_danish_ci
Column collation is utf8_danish_ci
Shouldn't setting a collation on the table/column overwrite collations on a higher level?
My website is all UTF8, and when I input text from the website, it comes fine our again. But when I look at the text in phpmyadmin, characters are displayed wrongly.