Sort order is not working properly

Hello

I have a site www.saludymedicinas.com.mx, which i have included wayfinder to generate a menu. Everything is working fine until i noticed that the order of my menu is no working well,(here example, http://www.saludymedicinas.com.mx/centros-de-salud/salud-infantil/articulos/bajo-crecimiento-infantil.html)

The menu in the left side is not sorting correctly, and in my wayfinder code is sortBy='pagetitle', i tried sortBy='menuindex'

Why is the order a ", then 5, the letter A, the letter Í, then ¿, and then B?




thanks

It probably is because of your database's character set and collation. The collation is what determines how strings are sorted, especially strings beginning with non-ASCII (English) characters.

Quote from: sottwell at Dec 03, 2014, 08:27 PM

It probably is because of your database's character set and collation. The collation is what determines how strings are sorted, especially strings beginning with non-ASCII (English) characters.

Thanks Sottwell, i checked my DB and its collation = latin1_swedish_ci,

Im from México,and i need accents displayed properly, can i change the collation to my entire DB without any risk(loose any data or not working when i query the DB)?


Where do i find character set for db?

I think it should be utf8_spanish_ci... is that correct?

That would certainly do the job. You can fix your database with this http://bobsguides.com/convert-db-utf8.html

Make sure to read the whole tutorial carefully before you use the script. And do make a backup of the database first.

Quote from: sottwell at Dec 04, 2014, 05:28 AM

That would certainly do the job. You can fix your database with this http://bobsguides.com/convert-db-utf8.html

Make sure to read the whole tutorial carefully before you use the script. And do make a backup of the database first.

Thank you so much, ill try this and if it works, ill reply XD