Cyrillic, Greek and Hebrew Characters Not Being Displayed Correcly in Alteryx

I'm trying to read data from a MySQL Server database using the Connect In-DB tool to be written to another database. I just noticed that Cyrillic, Greek and Hebrew characters aren't being displayed correctly and instead are being displayed as a series of question marks.

Please help.

Developer

Developer Tools

Output

Best Practices

In Database

In-Database

Accepted answers

apathetichell

MySQL I believe allows you to choose between ANSI and UTF8 at the driver level. Make sure your ODBC 64 is configured for UTF8.

All comments

Deano478

hey @RonGatmaitan this usually means that the encoding was used so you'll will need to choose the correct code page for your non-English character sets

RonGatmaitan

Hi, @Deano478. How do I do that?

apathetichell

MySQL I believe allows you to choose between ANSI and UTF8 at the driver level. Make sure your ODBC 64 is configured for UTF8.

RonGatmaitan

Hi, @apathetichell. Turns out the MySQL driver I'm using actually has 2 versions - ANSI and Unicode. I just had to use the Unicode driver. Accepting your answer as solution. Thank you!

apathetichell

That was my memory (which is pretty bad) but when I went to the Oracle download page I didn't see the dueling drivers - I just remembered it had something to do with ANSI vs Unicode options (and I do see my MySQL is labeled specifically as Ansi) Could be that I used a different link for the drivers... note - Postgres does something similar.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703