Community
Select to view content in your preferred language

SQL database (2022) Collation for UN

227
5
3 weeks ago
forestknutsen1
by MVP Alum
MVP Alum
3 weeks ago

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.

Tags (1)
0 Kudos
5 Replies
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
2 weeks ago

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

0 Kudos
forestknutsen1
by MVP Alum
MVP Alum
2 weeks ago

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.

0 Kudos
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
2 weeks ago

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

- V

0 Kudos
forestknutsen1
by MVP Alum
MVP Alum
2 weeks ago

Okay, my bad. So, this Latin1_General_100_CI_AS_KS_WS?

0 Kudos
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
2 weeks ago

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

- V

0 Kudos