Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Issue with Chinese characters

Ramaswami
Level 4
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
Manoj_Kumar_
Correct answer by
Community Advisor
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

View solution in original post

1 Reply
Manoj_Kumar_
Correct answer by
Community Advisor
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

View solution in original post