Support Article
Importing to data type converts Arabic Text to ???? (Nvarchar)
SA-88976
Summary
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
- Create any data type such that one of the columns is of Nvarchar type.
- 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.
Resolution
Perform the following local-change:
- Add Dynamic System Settings (DSS) to change pxtextuploadencoding to UTF-8.
- Restart the system.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.