We are setting up a new SQL database (2022) for the UN (Portal 11.5 / Pro 3.5) and I would like some help picking the new collation. My research is suggesting sql_latin1_general_cp1_ci_as, but I also see some post suggesting it is a legacy collation and that modern apps should use a Unicode-compliant collation.
We only have to support the English language.
