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
|