You can translate the question and the replies:

why no i18n for china? mysql8 datetime issuse.

why no i18n for china? recently we met a issue, if data source is mysql8, when get result from denodo , datatime type column result will be different from mysql8 table.
user
01-05-2021 03:56:30 -0400
code

1 Answer

Hi, For this scenario, I could create a **custom map** by performing the following steps in the VQL Shell of the Virtual DataPort Administration Tool: 1. Create a custom i18n map and change the values of different parameters according. 2. Configure this custom i18n map to be used during execution by selecting this i18n in the following sections of Virtual DataPort Administration Tool: * Tools > Admin Tool Preferences > Locale. * Corresponding databases by navigating to ‘Administration > Server configuration > Dafault I18n’. * Required base views by clicking on ‘Options > Search Methods >Default i18n option’. For more information, you can have a look at the [Managing Internationalization Configurations](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/advanced_characteristics/creating_new_internationalization_configurations/creating_new_internationalization_configurations#:~:text=Time-,internationalization%20configuration,-us) section under the Virtual DataPort Administration Guide which provides the details on custom i18 map creation and Knowledge Base article [Internationalization configuration and dates](https://community.denodo.com/kb/view/document/Internationalization%20configuration%20and%20dates?tag=i18n). Hope this helps!
Denodo Team
03-05-2021 05:36:08 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here