Kurre Posted March 21, 2019 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 ?
MrPhil Posted March 21, 2019 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.
Kurre Posted March 22, 2019 Author 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.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.