Hey. I'm trying to do `query.orderBy(column)` This column is a string column, and I want the `orderB...

# exposed

[Agustin Magne]

Hey. I'm trying to do query.orderBy(column)
This column is a string column, and I want the orderBy statement NOT to be case sensitive. How can I achieve that? (without changing the column altogether to .lowercase()

[Bogdan]

https://stackoverflow.com/questions/2413427/how-to-use-sql-order-by-statement-to-sort-results-case-insensitive/2413833
alas, that's just the way it is. I did not find a ready-made collate operator, but you can write it

MyTable.selectAll()
   .orderBy(MyTable.name.lowerCase())

[Agustin Magne]

You're correct. That's the way to do it! Thank you 😄