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:
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.
A defect or configuration issue in the operating environment.
Perform the following local-change:
- Add Dynamic System Settings (DSS) to change pxtextuploadencoding to UTF-8.
- Restart the system.
0% found this useful