Support Article

Need to change Column type of Operator and Org tables

SA-36375

Summary



User required to store field names in Chinese characters (double byte characters) in the DB table.

User required the Operator and Organization names too in Chinese characters (double byte character).

User would like to know if there is would be any adverse effect if the columns in Operator and Organization tables(pxOPName, pxOrgUnit and so on....) are changed.


Error Messages



Not Applicable


Steps to Reproduce



Not applicable


Root Cause



Japaneese or Chineese Characters are not storing in DB correctly.

Resolution


As part of HFix-32735, Pega added support at the DB layer to store the NVARCHAR columns and also to fetch the values from Report Definition.

After installing the hotfix,all the required columns need to be converted from Varchar to NVarchar.

User can also convert the OperatorName and OrganizationUnit columns in the similar way.

There will not be any adverse effect in converting these columns.

Published April 12, 2017 - Updated April 26, 2017

Have a question? Get answers now.

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