You can translate the question and the replies:

Incorrect script generated by DESC for i18

Related to: Number of decimal places using i18n map
-- doubledecimalseparator should be '.' instead of '' DESC VQL MAP i18n us_pst # Generated with Denodo Platform 8.0. DROP MAP i18n IF EXISTS us_pst CASCADE; CREATE MAP i18n us_pst ( 'country' = 'US' 'datepattern' = 'MMM d, yyyy h:mm:ss a' 'datesubtypepattern' = 'MMM d, yyyy' 'doubledecimalposition' = '2' 'doubledecimalseparator' = '' 'doublegroupseparator' = '' 'language' = 'en' 'timesubtypepattern' = 'h:mm:ss a' 'timezone' = 'PST' ); Thanks, Ruby
user
28-05-2021 13:52:17 -0400
code

1 Answer

Hi, In some of the default i18n like US_PST of Virtual DataPort, the empty string in doubledecimalseparator property denotes the default decimal separator in Java (probably "."). In order to use a different doubledecimalseparator, I would create a new I18N by using the below command: ``` CREATE OR REPLACE MAP I18N <map name> ( 'country' = <value> 'datepattern' = <value> 'doubledecimalposition' = <value> 'doubledecimalseparator' = <value> 'doublegroupseparator' = <value> 'language' = <value> 'timepattern' = <value> 'timezone' = <value> ); ``` You could refer to the section [Managing Internationalization Configurations](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/advanced_characteristics/creating_new_internationalization_configurations/creating_new_internationalization_configurations#managing-internationalization-configurations) for more information. Hope this helps.
Denodo Team
02-06-2021 03:04:59 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here