The Oracle SQL query returns some data in the Hebrew language encoded as "?

Feedback Activities
,
1

The Oracle SQL query returns some data in the Hebrew language encoded as “???”

How do I fix this?

3

@or.chasson

What type of columns are those?

What is the data?

Cheers

4

Hi @or.chasson,
we need more details as mentioned from @Anil_G in above reply however this issue maybe due to inaccurate character encoding type most encoding type to be used is “UTF-8” (Unicode).

please check and update us with the requested data if you still face the same issue.

5

When running a query in Oracle that outputs Hebrew text, it is visible as written.
However, when running the same query in UiPath, the output appears as question marks (???) instead of the Hebrew text.

7

@mahmoud.zaky @Anil_G

8

@or.chasson

What drivers are you using…can you try with a different set of drivers

Also can you show the connection string try adding a characterset attribute to your connection string and check

Cheers

9

Hi @or.chasson

Did @Anil_G suggestion from above help you resolve the issue?

If not, would be be kind to provide the mentioned extra context? We will look into it.

It would also be helpful to know the Studio version and the Database activity package version, as well as your Studio project type (Legacy/Windows) and language (vb.net/c#).