Issue with "Execute Query" activity with query containing greek characters

Help
, ,
1

Hello all,

This is my first post in the forum. Glad to be part of the community.

I encounter an issue with the following process:

With the “Execute Query” activity, I run a query to an Oracle database with a where clause with a greek value.
Query example: “select * from rpatest where column3=‘τεστ’”
Connection string example: “Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)(CONNECT_DATA=(SERVICE_NAME=xxxx)));User Id=xxxxx;Password=xxxxxx”

The query runs properly but because of the greek value I get no results, if I remove it (or replace the value with latin characters) I get normal results (even greek-valued ones).
When I try the same query in different tools (ex. SQL Developer, Toad etc.) it works normally.

Maybe I need to add a character encoding in the connection string or something is not supported for unicode characters?

Let me know if I can provide more info.

Thank you for your help in advance,
Lampros