Changing Data Studio's default Language and Region setting

Henry Simms
Henry Simms Administrator
edited December 2023 in Administration

I recently needed to change the default Language and Region setting used by Data Studio when adding a new Dataset:

image.png

The Language and Region setting controls how date and numeric values are parsed on load (if detecting data types). For example:

  • Dates: English (United Kingdom) will parse the value "01\02\2020" as 1st February 2020, English (United States) will parse the same value as 2nd January 2020.
  • Numbers: English (United Kingdom) will parse the value "1,001" as the number 1001, German will parse the same value as "1.001"

The default language \ region will be picked up from the server's system settings. The default locale can be over-ridden in the Aperture Data Studio Service 64bit.ini file's Virtual Machine Parameters by adding the following settings at the end of the line:

-Duser.country=US -Duser.language=en

Which changes the default (for all users) to:

image.png

The Java documentation has a full list of the available country and language combinations.

You can find Aperture Data Studio Service 64bit.ini in the installation root directory (default C:\Program Files\Experian\Aperture Data Studio <version>).

Comments

  • Henry Simms
    Henry Simms Administrator
    edited October 2023

    Data Studio now uses Java 17, so the list of supported county and language combinations may have been updated, Here's the updated documentation for Java 17

    Specify United States default parsing using: -Duser.country=US -Duser.language=en

    Specify United Kingdom default parsing using: -Duser.country=GB -Duser.language=en

Categories