UTF-8 character problem in the "TEXT" field - Data Transformation(MySQL)
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:
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
Hi Merve,
Thanks for your question.
Would you be able to clarify where you are seeing this output? Is it in your Data Source, in Yellowfin, or somewhere different? Does the data look accurate in the DBMS?
I suspect that everything is fine from the Yellowfin side - the connection string is correct. One thing that you could try, is to use a third-party tool such as DBeaver or DBViz using the same connection string and observe the output for the Turkish characters. If the third-party tool also displays Turkish characters with '?', then the issue is most likely Database related.
Then, it would be worth checking the encoding is correct in the Database by running the query below. Where the results should be 'utf-8' rather than 'latin1' or another encoding method.
Kind regards,
Simon
Comments have been locked on this page!