When sorting data in Croatian, the sorting result is inaccurate.
This problem does not occur when sorting data in English.
The problem creates diakrytic signs: Š, Đ, Č, Ć, Ž.
//for example
$this->loadModel(‘BlogPosts’);
$blogPosts = $this->BlogPosts->find(‘all’)->order([‘BlogPosts.title’ => ‘ASC’])->toArray();
pr($blogPosts);
The sorting result is:
…[title] => Auris tristique vehicula urna idspe…
…[title] => Bauris rutrum dolor ligula sed euismod ante…
…[title] => Člass aptent taciti sociosqu ad litora torquent…
…[title] => Corbi imperdiet sollicitudin lacus ut bibe…
…[title] => Morbi a ipsum et lorem venenatis luctus…
…[title] => Pellentesque euismod ante nibh eu viverra…
…[title] => Rellentesque tortor dolor semper vitae elit et…
…[title] => Đonec semper orci nec egestas condime…
Sorting is incorrect. It should be:
…[title] => Auris tristique vehicula urna idspe…
…[title] => Bauris rutrum dolor ligula sed euismod ante…
…[title] => Corbi imperdiet sollicitudin lacus ut bibe…
…[title] => Člass aptent taciti sociosqu ad litora torquent…
…[title] => Đonec semper orci nec egestas condime…
…[title] => Morbi a ipsum et lorem venenatis luctus…
…[title] => Pellentesque euismod ante nibh eu viverra…
…[title] => Rellentesque tortor dolor semper vitae elit et…
Croatian alphabet:A, B, C, Č, Ć ,D, Dž, Đ, E, F, G, H, I, J, K, L, Lj, M, N, Nj, O, P, R, S, Š, T, U, V, Z, Ž
How to solve this problem?