Dafactory-CopyアクティビティSourceのQueryに全角文字は文字化けになり、検索できないについて

Question

SalesforceからSOQLを利用してデータを抽出するとき、
検索条件に全角文字があるとデータ抽出できません。
全角文字は文字化けになったようです。
対策があるかご教示ください。

SOQL例： select id, name from account where name='アジュール'

<Adding English translation>
About Dafactory-Copy activity Source Query, double-byte characters are garbled and cannot be searched.
When extracting data from Salesforce using SOQL Data cannot be extracted if there are double-byte characters in the search conditions.
Double-byte characters seem to be garbled. Please tell me if there is a countermeasure.
SOQL Example: select id, name from account where name ='Azur'

Answer 1

@lee sc There is a property of the linked service which may help. The "language" property defaults to En (English) Can you try setting it to the language you are using in SAP?

If you do not see it in the Linked Service UI, then you can set it directly in the JSON.

Please let me know if this helps.

Answer 2

@MartinJaffer-MSFT
Thanks for your answer!
My test environment is Salesforce, not SAP.
I tried the following 2 methods in Salesforce link service,
But none of them worked.
"language":"ja-JP"
"language":"JP"

Json is:
{
"name": "Salesforce1",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"annotations": [],
"type": "Salesforce",
"typeProperties": {
"environmentUrl": "https://test.salesforce.com",
"username": "????????????",
"language": "JP",
"encryptedCredential": "???????????"
},
"connectVia": {
"referenceName": "IR-GeneralCore8",
"type": "IntegrationRuntimeReference"
}
}
}