Survey: Is it annoying when you cannot have a database with a collation other than en_US.UTF-8? If so, how annoying? #heroku
Conversation
Replying to
yes, very. If per column collation can't be changed, dealbreaker. If it can, just very annoying.
1
Replying to
I thought you'd say that. You can have per-column collations.
1
Replying to
:) the it still works, but it's a lot more work than if you can just set it on the database level.
1
Replying to
That's about what I thought. So average Swedish programmers would be bothered by collation issue? Not just DB geeks?
Replying to
definitely. Their data would be coming to back in the wrong order and they'd have to re-sort it in the application.
2
Replying to
unless they use an orm which creates tables with explicit collations automatically. I don't know which one that would be though