No ratings

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

 

 

Version history
Last update:
‎06-28-2021 02:26 AM
Updated by: