Expand my Community achievements bar.

SOLVED

Issue with Chinese characters

Avatar

Level 4

We have two table : 

Table 1: (say MCP ) 

Table 2: (say NMSRecipient ) 

 

MCP table's first name and last name is loaded into NMSRecipient schema through a workflow data loading activity based on a primary key such that if a primary key already exist in NMSRecipient table it updates the data and if primary key is not there in NMSrecipient table it will insert the row. 

First name and last name are inserted as below : 

Ramaswami_0-1588684020576.png

Using the Smart() function. 

 

now the first name in MCP table is looking good like below but in NMSRecipient table for the same respondent id the values look different: See the below SS the first two columns are from MCP table and last two are from NMSRecipient table the chinese characters are very different. Why is this so? any suggestions. 

 

Ramaswami_1-1588684143691.png

 

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Ramaswami ,

To fix this thing i would first check the character coding of the file which is being used by the Data loading activity and then the data type of the column first name and last name.

Thanks,

Manoj


     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @Ramaswami ,

To fix this thing i would first check the character coding of the file which is being used by the Data loading activity and then the data type of the column first name and last name.

Thanks,

Manoj


     Manoj
     Find me on LinkedIn