Issue with Chinese characters

Avatar

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile
Ramaswami
Level 1

05-05-2020

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

 

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

117 likes

Total Posts

329 posts

Correct reply

102 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

117 likes

Total Posts

329 posts

Correct reply

102 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

05-05-2020

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

Answers (0)