Incorrect string value error for special characters in customer addresses

  • 15Views
  • Last Post 3 weeks ago
  • Topic Is Solved
0
votes
Caleb Simonyi-Gindele posted this 3 weeks ago

Hi, 

I have a sync package that sends Quickbooks Online customers into a MySQL database. I am seeing sync errors for two customers where there are special characters in their addresses. I am wondering if there is a way these kinds of special characters can be handled without errors. 

One case is a City name: "Saint-André" and the error is "Incorrect string value: '\xE9' for column 'BillAddr_City' at row 1"

The other is a street name in Germany "Friedrich-Ebert-Straße" and the error is "Incorrect string value: '\xDFe 49' for column 'BillAddr_Line1' at row 1"

0
votes
Dmitriy Muzurov posted this 3 weeks ago

Hello Caleb,

Thank you for submitting a ticket with us.

We would recommend enabling Unicode check box in the Advanced Settings of your MySQL connection in Skyvia account.

Should you have any questions, do not hesitate to contact us back.

Close