Getting Junk Character while writing data on MySQL

[VJ_dup_337]

Guys,

I am creating a table on MySQL using Alteryx Output tool but when I am trying to write non-English characters in table I am getting ???? instead of the original text.

Any suggestion to avoid this issue or how can I convert this to English?

[PaulN]

Hi @VJ_dup_337,

Could you please show a screenshot of the results if you try to read the record using Alteryx?

Kind regards,

Paul Noirel

Customer Support Engineer

[VJ_dup_337]

Hey PaulN,

I have attached the sample workflow. request you to refer that.

Thanks!

[PaulN]

Hi @VJ_dup_337,

Your first screenshot doesn't show data when they are read from Alteryx but from another application.

For example, if I test your workflow on my machine and verify results, I obtain:

Kind regards,

Paul Noirel

Customer Support Engineer

[VJ_dup_337]

Hi @PaulN,

I am getting junk in output PFB.

[VJ_dup_337 · Accepted solution]

Hi @PaulN,

Thanks for help Paul.

As suggested, used mysql odbc 5.3 unicode driver and it works for me. 

Appreciate your quick help.