I have to save polish characters to my database.
Instead of polish characters in my table i see ? characters.
The probleam persist only if i insert rows from robot! If i insert from MySQL Workbench, everything works well!
I tried several options for Charset/Collation setting in my database on table and column too.
Not sure the activity handles properly the encoding with your query string or when communicating with the server (I have a lot of issues of this kind with UiPath “official” python package, for example, and I need to implement a workaround routine each time).
Can you try to set explictly the charset in the connection (Configure Connection...), for example, with a connection string?
Being explicit in the string encoding (or compensating an unwanted conversion by the UiPath activity with CONVERT or CAST) might also help