Wrong sort order of national characters

Previous topic

General

Next topic

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

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

eZ debug

Timing:	Jan 18 2025 16:18:44
Script start
Timing:	Jan 18 2025 16:18:44
Module start 'layout'
Timing:	Jan 18 2025 16:18:44
Module start 'content'
Timing:	Jan 18 2025 16:18:44
Module end 'content'
Timing:	Jan 18 2025 16:18:44
Script end

Main resources:

Total runtime	0.0133 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.0078	152.6250
Module start 'layout'	0.0055	0.0025	740.6328	39.4453
Module start 'content'	0.0079	0.0037	780.0781	89.4297
Module end 'content'	0.0116	0.0016	869.5078	30.3047
Script end	0.0132		899.8125

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	16.7752	14	0.0002
Check MTime	0.0010	7.4658	14	0.0001
Mysql Total
Database connection	0.0008	5.9514	1	0.0008
Mysqli_queries	0.0028	21.0324	3	0.0009
Looping result	0.0000	0.0612	1	0.0000
Template Total	0.0014	10.2	1	0.0014
Template load	0.0007	4.9047	1	0.0007
Template processing	0.0007	5.2950	1	0.0007
Override
Cache load	0.0005	3.5306	1	0.0005
General
dbfile	0.0003	2.2554	8	0.0000
String conversion	0.0000	0.0450	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs