One Star

Multilingual MySQL Database

Hello,
we plan to design our MySQL Database with multi language support for different tables. We would like to have any tutorials or if possible any free-trial products, which help us to reach the best possible structure consistent with Talend Open Studio 5.4.1.

Regards,
Amir
2 REPLIES
Moderator

Re: Multilingual MySQL Database

Hi,

For your requirment, have you tried to alter database DEFAULT CHARACTER SET as UTF-8?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Multilingual MySQL Database

Yes, the char set is utf-8. I'm more concern about the structure of tables for storing data in different languages. For instance, the link below gave me some good hints, or see the attachments.
The question is whether the multilingual fields (or tables) are supported in some Talend products, or is there any preferences for designing tables, so that talend can work with them better.
Amir