Arabic characters are stored as ?? in Oracle database when using Execute SQL action

Issue

When using Execute SQL action to store Arabic text in Oracle database, Arabic characters are replaced with question mark symbols "????"

Error Code

Resolution

Include the parameter 'Unicode=true' in the connection string for the database within Execute SQL action. 

Connection string format:

Data Source=<dataSource>;User Id=<userId>;Password=<password>;Unicode=true

Additional Information

Related Links