Need to change Column type of Operator and Org tables
SummaryUser 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 MessagesNot Applicable
Steps to ReproduceNot applicable
Root CauseJapaneese or Chineese Characters are not storing in DB correctly.
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