Follow
When using SQL as datastore for your application. Do you prefer a collation that is
@serra Doesn’t make sense to have a preference for that. This decision should be made separately for each column.
@chloekek What would you choose as default value when you don't specify case sensitivity?
@serra The special “C” collation, as it’s the simplest one that just calls memcmp. If you need something more complex then a default won’t do well anyway. There are many parameters you can choose from, besides case-sensitivity, such as language and whether to recognize multi-digit numbers.
I had a somewhat interesting bug at work regarding case insensitivity: https://dev.direkt-gruppe.de/2020/09/28/ccccc/