Working with Danish translations


Description

Sitecore stores Danish translations using the ISO code "da" in the default distributive of Sitecore CMS, Intranet Portal, localization files and Sitecore modules.

Solution

To be able to localize parts of the Sitecore Client interface, such as template sections, field names and descriptions, it is recommended to use the "da" language instead of "da-DK" in Sitecore content databases, such as master and web.

If the ISO codes in the core and master databases are different, they may cause issues related to being unable to translate parts of Sitecore Client interface, such as template sections, field names and descriptions.

To add a "da" language to a Sitecore solution that does not yet have Danish language in a content database:

  1. Go to /sitecore/system/Languages node and select the Insert Language option to start the Language Creation Wizard.
  2. In Language Creation Wizard, select a predefined Danish (Denmark) language.
  3. Note: Skip this step when running Sitecore CMS 6.5.0 or later. Change Country/Region Code value from "DK" to an empty value, click Next.
  4. Follow the wizard instructions to complete the language creation process.

If an existing solution is already utilizing a "da-DK" language, perform the following steps to switch to using "da" language:

  1. Backup your Sitecore site and databases.
  2. Set the value of Regional Iso Code field of /sitecore/system/Languages/da-DK item to "da" instead of "da-DK" in master and web databases.
  3. Rename the item to "da" from "da-DK" in master and web databases.
  4. Stop the Sitecore web site in IIS.
  5. Run the following SQL query against the master and web databases:
    UPDATE UnversionedFields SET Language='da' WHERE Language='da-DK'
    UPDATE VersionedFields SET Language='da' WHERE Language='da-DK'
  6. If OMS is used, run the following SQL query against the analytics database:
    UPDATE Page SET ItemLanguage='da' WHERE ItemLanguage='da-DK'
    UPDATE PageEvent SET ItemLanguage='da' WHERE ItemLanguage='da-DK'
  7. In the Sitecore web.config file and files from /App_Config/Include folder, change all "da-DK" language references to "da".
  8. Start the Sitecore web site in IIS.