Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Importing to data type converts Arabic Text to ???? (Nvarchar)



A data type is created and is delegated to the user.

When editing or manually adding data, the individual entry data is saved in Arabic because it is configured in the column as Nvarchar. However, when using the Import functionality, data is imported as '????' as below image displays.

Database used: SQL Server (Collation: SQL_Latin1_General_CP1_CI_AS)

Table displays as below:

Error Messages

Not Applicable

Steps to Reproduce

  1. Create any data type such that one of the columns is of Nvarchar type.
  2. Use the Import functionality of the data type to which the database is configured (Collation: SQL_Latin1_General_CP1_CI_AS). The data is inserted as '???' instead of Arabic text.

Root Cause

A defect or configuration issue in the operating environment.


Perform the following local-change:
  1. Add Dynamic System Settings (DSS) to change pxtextuploadencoding to UTF-8.
  2. Restart the system.

Published December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us