topic SQL database (2022) Collation for UN in Geodatabase Questions

SQL database (2022) Collation for UN

forestknutsen1 — Tue, 11 Nov 2025 17:11:05 GMT

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.

Re: SQL database (2022) Collation for UN

VinceAngelo — Wed, 12 Nov 2025 15:48:23 GMT

I've been UTF-8 compliant on my databases for 22+ years now. There really is no reason to go out of your way to make international names like "Côte d'Ivoire" give your front-end developers nightmares.

- V

Re: SQL database (2022) Collation for UN

forestknutsen1 — Wed, 12 Nov 2025 19:05:18 GMT

Okay, so you think we are fine with sql_latin1_general_cp1_ci_as. I think that is the answer I want to hear -- keep it simple wherever possible.

Re: SQL database (2022) Collation for UN

VinceAngelo — Wed, 12 Nov 2025 20:48:33 GMT

No, latin1 is NOT UTF-8, it's latin1. You need to use a UTF-8 character set.

- V

Re: SQL database (2022) Collation for UN

forestknutsen1 — Wed, 12 Nov 2025 22:13:53 GMT

Okay, my bad. So, this Latin1_General_100_CI_AS_KS_WS?

Re: SQL database (2022) Collation for UN

VinceAngelo — Wed, 12 Nov 2025 22:23:20 GMT

According to Stack Exchange, you want Latin1_General_100_..._UTF8

- V