Sorting with non-english-characters

  • Hi!

    First of all, thanks for a great plugin! I only have one small problem. I hope it’s not answered before, I couldn’t find it in the help section.

    I’m using it on a Swedish site, and the Swedish alphabet is a-z and then ??? (??? in uppercase) as the last 3 letters. When listing all the members in Participants Database, ??? are treated as a and o. Members with last names starting with these letters therefore end up in the wrong place when listed.

    I have changed the COLLATE to utf8_swedish_ci without success, but the search function worked as it should even before that so I guess that’s not the problem.

    Any ideas would be very appreciated!

    Regards,
    J

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Changing the COLLATE is what you need to do, just make sure you’re choosing the right one. Also it is important that your web pages be encoded in UTF-8 so that the data is stored with that encoding. This is the default in most cases, but it’s good to check it.

    The COLLATE change in the database may not affect existing records, I don’t know about that. Try testing it with new entries, see if those sort in the correct order.

Viewing 1 replies (of 1 total)
  • The topic ‘Sorting with non-english-characters’ is closed to new replies.