We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

set IN-DB tool reading as utf-8 (WString)

Krit_Gable
8 - Asteroid

I have a question regarding in-db tools,

I didn't have problem on connection and read data from MYSQL normally 

 

However, when I start to read other language beside English. The metadata of in-db read as String which make other langauge read as ?????. I did try to convert via select tool but it didn't solve. 

 

I am curious is there a way to change connection input from database as  utf-8 format

 

Thank you in advance

3 REPLIES 3
EddieW
Alteryx
Alteryx

Hi @Krit_Gable,

 

Have you tried converting the specific columns to utf8 using the "Formula In-DB" tool? See below link:

 

https://stackoverflow.com/questions/16051369/convert-output-of-mysql-query-to-utf8

Eddie Wong
Customer Support Engineer
Alteryx
Krit_Gable
8 - Asteroid

Thank you, I already tried that but it didn't work . However, I already fixed by casting data as nchar()  instead of nvarchar()  or casting formula as utf-8 and it work perfectly

Mrinal_Dubey
5 - Atom

Hi Can you please share how you resolved it in Formula In-DB? 

I have a similar issue in which i am not able to read Chinese characters from In-DB SQL query

Labels