UTF-8 character problem in the "TEXT" field - Data Transformation(MySQL)

Merve shared this question 2 years ago
Answered

Hello,

I transfer data from one data source to another data source(MySQL databases)

Data transfer appears to be successful. However, the characters in the "TEXT" field appear incorrectly in the target table in database. There are symbols like question mark(?) instead of Turkish characters. So I am having UTF-8 character problem during data tranfser.

My connection settings:

/595fd80c9d3e4296c2fa3b854e672226

I tried "databasename?characterEncoding=utf8" in the Database Name box. But it didn't work.(Yellowfin Version: 9.7.1 and Java Version:11.0.8)

Is there any way to solve this problem?

Regards,

Merve

Replies (2)

photo
1

I tried to connect excel to mysql and I found a tool for this. So you can try it also.

photo
1

Hello Merve,

Are you needing any more help with this?

David

Leave a Comment
 
Attach a file