Database collates are ridiculous. Why would I want to globally configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres#mysql #databases #rdbms #programming

Database collates are ridiculous. Why would I want to globally configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres#mysql #databases #rdbms #programming