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,