Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Getting Junk Character while writing data on MySQL

VJ_dup_337
7 - Meteor

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?

 

Inked1_LI.jpg

2.PNG

5 REPLIES 5
PaulN
Alteryx Alumni (Retired)

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
7 - Meteor

Hey PaulN,

 

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

 

Thanks!

 

PaulN
Alteryx Alumni (Retired)

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:

 

 

MySQLTest.png

 

 

Kind regards,

 

Paul Noirel

Customer Support Engineer

VJ_dup_337
7 - Meteor

Hi @PaulN,

 

I am getting junk in output PFB.

 

 

msl.PNG

 

VJ_dup_337
7 - Meteor

 

 

 

Labels