I have a new server (Windows 2022) and I need to install SQL 2022 with the collation to be Latin1_General_CI_AS, but in the setup there is no option to allow this, see the screenshot.
How can I set the collation in SQL to Latin1_General_CI_AS when I am forced to accept Latin1_General_CP1_CI_AS?
SQL Install Collation Options:
I have insured the locale and timezone on the server is correct (UK) compared server install to another identical server which has as default Latin1_General_CI_AS like I need
Checked the server default codepage (437)
Robert Cooper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2