Question 20660 in Mysql Question posted in
The official MySQL documentation can be found here.

Trouble sorting DDanish letters correct in MySQL

In MySQL I have a table with zipcodes and cities. In the database fx. Copenhagen (København) i shown as København, but written in PHP it is correctly shown as København. The table is utf8_general_ci.

When I want to get the entire list of citites, the sorting goes wrong.

København is comming before Kerteminde and Ølgod is before Bogense and that is wrong.

I have tried with ORDER BY city COLLATE ‘utf8_danish_ci’ asc in my SQL, but that doesn’t work.

How can I sort the cities correctly?

Tags:

2

Answers


  1. 0

    If the table is loaded with the correct encoding, are you sorting it before or after the encoding?

    One solution might otherwise be to sort it with another encoding, and then use the desired one to render the final product, although a makeshift one.

    Login or Signup to reply.
  2. 0

    You should set the mysql/mariadb connection to UFT-8. This code should be placed directly after connecting to your database.

    mysql_set_charset("utf8");

    or

    $mysqli->set_charset("utf8");
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search