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

[Krit_Gable]

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

[EddieW]

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

[Krit_Gable · Accepted solution]

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]

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