Add Optional ISO-code Locale to Content Data Model

Parent Issue

https://github.com/dotCMS/core/issues/25603

Task

We want to support 2-letter ISO Language Codes, as well as 2-letter Country Codes; combined those 2 codes would make a Locale Code.

We want to make this change system wide, including how we store languages and locales in the database.

Some example language codes…

EN - English
ES - Spanish
NO - Norwegian

List of ISO 639-1 codes - Wikipedia | https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

Some example country codes…

US - The United States
CR - Costa Rica
AU - Australia

List of ISO 3166 country codes - Wikipedia | https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes

Some examples of locale codes…

EN-US - English for The United States
ES-US - Spanish for The United States
ES-CR - Spanish for Costa Rica

Proposed Objective

Core Features

Proposed Priority

Same as Parent

Acceptance Criteria

We'll need to support the legacy query string variable for languages, but we'll also want to support Locales for languages.

Content could be referenced by 4-letter Locale ID, or 2-letter Language ID. We'll want to focus on 4-letter codes being the "default" option. (Keep in mind there is no such thing as "English" just American English, UK English, Canadian English, Australian English, and so on. The same is true for all languages. Hence the focus on Locales.)

EN-US
EN
ES-CR
ES

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

Localized Versions of your Pages | Google Search Central | Documentation | Google Developers | https://developers.google.com/search/docs/specialty/international/localized-versions#language-codes

dotCMS / core