Hi, ALL, In the CREATE DATABASE statement I can use encoding/collation/ctype.
I can retrieve the encoding list with:
[code] SELECT pg_encoding_to_char( conforencoding ) AS name FROM pg_conversion [/code]
And then I can get a list of collations/ctypes with:
[code] SELECT collname, collencoding, collprovider collctype FROM pg_collation [/code]
And then add a logic in my UI to switch collations/ctypes based on encoding.
However, what I wonder is:
Is there a way to select a default collation/ctype for a specific encoding?
Or maybe I'm overthinking it and I should let the user choose and if nothing - just keep those 2 as "Default" and let the server pick it up. However it will be weird, especially from me as a user POV.
You know your data, not us. The first question I'd try to is "how much client text data is not compatible with bog-standard UTF8?"
