Kurre Posted March 21, 2019 Share Posted March 21, 2019 2.3.4.1 CE BS version I have swedish language and we have characters like åäö in it, but it is not alphabetical on the product listing right now, character å is shown first before a and so on,how can I make it alphabetical in swedish ? Link to comment Share on other sites More sharing options...
MrPhil Posted March 21, 2019 Share Posted March 21, 2019 Unless you changed something in the database setup, the encoding is UTF-8 and I think the collation is "utf8_unicode_ci", which is case-insensitive and ordered by Unicode number (don't quote me on that last part). I would think that accented characters would come after ASCII, so I'm a bit puzzled at your results. Ironically, the older osC releases used Swedish collation (on Latin-1) as the default! Anyway, I would first look at your database collation order to see if it's set to something weird, and then search around for information on what collations are available for MySQL. There may yet be a UTF-8 Swedish one. Link to comment Share on other sites More sharing options...
Kurre Posted March 22, 2019 Author Share Posted March 22, 2019 Thanks for the answer @MrPhil ! There was a utf8_swedish_ci collation I could change to in the database that solved the problem. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.