Insert non English characters into MySQL using Activities.ExecuteNonQuery turned into question marks

Help Studio
, , ,
1

Hello,

I am trying to insert Chinese characters into MySQL "一二三四“ into MySQL and the column’s charset is currently “utf8mb4” and collation utf8mb4_0900_ai_ci. The problem i am facing right now is inserting using UiPath.Database.Activities 1.8.2 the saved characters turned into “???” but when i inserted directly using workbench it works fine.

Is there any step i have missed out that cause the problem?

"

UPDATE Table1
SET name_table = ‘“& “一二三四” &”’
WHERE name_table = ‘???’;

"

2

Hi @jiawei - Check Database Connection Configuration from UiPath, while creating connection provided this Charset=utf8 inside the connection string.

3

I think I have found the problem. Sigh… the issue was with ODBC driver. I was using ANSI instead of UNICODE :rofl:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.