Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product listing swedish characters åäö


Kurre

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...