Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006

    Unanswered: MySQL ordering problem with utf8


    I have a MySQL table with CHARSET=utf8 COLLATE=utf8_unicode_ci
    My problem is that if I want to order by name for example then the list is not really correct. The words with only english characters are ordered fine, but if there are any non english character like éőó, then they will be placed in a wrong position.

    Any idea how to solve it?

  2. #2
    Join Date
    Aug 2006
    Some more details:

    MySQL version is 5.0.x (depends on server )
    OS: XP Pro, XP Home, Vista Home Premium, Vista Ultimate, Linux (depends on server). The problem exists everywhere.

    Wrong order: Let's say we have a column "word" with 2 records: apple and önt. The correct order is:
    1. apple
    2. önt

    But the "order by word asc" results:
    1. önt
    2. apple

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts