Changing Data Studio's default Language and Region setting
I recently needed to change the default Language and Region setting used by Data Studio when adding a new Dataset:
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:
Which changes the default (for all users) to:
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>).