Forums / General / Wrong sort order of national characters

Wrong sort order of national characters

Author Message

dexen deVries

Tuesday 06 February 2007 3:43:59 am

Hi,

I'm using eZ Publish 3.8.6 with a MySQL DB engine, in UTF-8 setup. The site in question in Polish, nodes fetched with

{fetch( 'content', 'list', hash( 'parent_node_id', SOME_ID, 'sort_by', array( 'name', 1 )  )  ) } 

are sorted in wrong order:
a...z first, and national characters afterwards, while proper order would be
a, [a_ogonek], b, c, [c_acute], d, e, [e_ogonek], f, (...)

The database itself is set to ``utf8_general_ci'' collation, but eZ P's tables are sporting ``utf8_bin'' .

Is this behaviour normal to eZ P, or do I fill a bugreport?

Is it safe to change collation of the tables? Or is it pointless?

Anja Lundin

Tuesday 24 March 2009 1:10:59 am

Hi dexen!
I know this is an old post, but I had the same problem as you (but with swedish Å Ä Ö) and I looked for a solution in the forum and found nothing.

I solved my problem with changing the collation of the database and all it's tables. In my case to utf8_swedish_ci and it works great after this!

Best regards!
Anja Lundin, Novitell AB

------------------------------------
Anja Lundin
Developer, Novitell AB
Sweden

www.novitell.se