Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
Top Solution Authors