What happened?
When I try to sort a list of entries alphabetically using a plain text field value (other kinds of fields behave as expected), the sorting process is taking accents into account, but it should be accent-insensitive. Database character set is utf8mb4 and collation is utf8mb4_0900_ai_ci.
Craft CMS version
Craft Solo 5.3.6
PHP version
8.3.6
Operating system and version
Linux 6.8.0-36-generic
Database type and version
MySQL 8.0.39
Image driver and version
Imagick 3.7.0 (ImageMagick 6.9.12-98)
Installed plugins and versions
No response
What happened?
When I try to sort a list of entries alphabetically using a plain text field value (other kinds of fields behave as expected), the sorting process is taking accents into account, but it should be accent-insensitive. Database character set is utf8mb4 and collation is utf8mb4_0900_ai_ci.
Craft CMS version
Craft Solo 5.3.6
PHP version
8.3.6
Operating system and version
Linux 6.8.0-36-generic
Database type and version
MySQL 8.0.39
Image driver and version
Imagick 3.7.0 (ImageMagick 6.9.12-98)
Installed plugins and versions
No response