PureEngage On-Premises

the value of  Attribute in database table contains Chinese character.
First Querying the Attribute and assign it to a variable A1.then geting specified length from the variable A1 and assing it to variable A2.
Querying db with variable A2 .
however , Chinese character becomes "?" in variables which resulting to the query is null.

what's wrong here and how to fix it? Thanks.

Hello Koven,

you need to track entire communication from URS to database itself. There are several place where the character set can be changed dynamically. What charset is used within your database? What is your platform on OS level - if Windows, what is your region setting? Did you install all language packages, etc.? If Linux, check your env settings.

Regards,
--Jakub--