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.
Follow

@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.
Sign in to participate in the conversation
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.