mirror of
https://github.com/doctrine/orm.git
synced 2026-03-24 06:52:09 +01:00
DDC-2730: Natural ordering in QueryBuilder #3417
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Oct 9, 2013).
Originally assigned to: @Ocramius on GitHub.
Jira issue originally created by user sergio.pavon:
Maybe this is not the best place to ask for a feature supported by doctrine. I apologize if I've chosen wrong channel.
Hi,
I can't find an easy way to do natural text ordering with QueryBuilder. OrderBy lets us order text, but I want to order including accents and other simbols. For instance, if we have this words:
Alabama, Boston, Álamo, Cardiff.
Natural order: Alabama, Álamo, Boston, Cardiff.
But current Doctrine order: Albama, Boston, Cardiff, Álamo.
I know that I can create a custom function or use native query, but I think that natural order often occurs. There are DBMS specific functions like TRANSLATE or REPLACE that can help, but I think that doctrine not support them.
Thank you,
Sergio.
@doctrinebot commented on GitHub (Oct 17, 2013):
Comment created by @ocramius:
This depends on the collation of your DB/Table/Column, not on Doctrine itself.
@doctrinebot commented on GitHub (Oct 17, 2013):
Issue was closed with resolution "Invalid"