azure datafactory copy data how to query from salesforce with japanese characters where condition

Question

Use azure data factory copy data activity to query data from salesforce.
If SOQL where statement have Japanese characters , can not query data.
Example: 1 and 2 query 0 data, and 3 can query 1 data.
1, "SELECT id, name from account where name =" 名称1'"
2, "SELECT id, name from account where name like '名称%'"
3, "SELECT id, name from account where name like'%1'"

Please tell me how to solve it. Thank you very match!

Answer 1

anonymous userChaudhari

The below SOQL can query.

　 WHERE NAME = CAST('名称1' AS VARCHAR)

Thank you very much!

Answer 2

If you are looking for a SQL query, you can use N in where clause like below:

WHERE name = N'名称1'

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav