MySQL update row value: Error, incorrect string value

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
BiBo
Posts: 2
Joined: Wed 26 Aug 2020 10:04

MySQL update row value: Error, incorrect string value

Post by BiBo » Wed 26 Aug 2020 10:27

Hello, I try you add-on for MySQL.
When I try to update string row in English language: Commit is Ok.
And if I try to update same string row in Russian language: Commit is Error, incorrect string value.
You add-on not support Russian language in value?
Is possible to fix it?
UPDATE:
get data if string value is Russian language i see unreadable characters.

AlexBrown
Posts: 6
Joined: Wed 06 Jun 2018 11:02
Contact:

Re: MySQL update row value: Error, incorrect string value

Post by AlexBrown » Wed 18 Nov 2020 10:26

It says it does support but actually it doesn't

dm-m
Devart Team
Posts: 8
Joined: Tue 06 Aug 2019 07:43

Re: MySQL update row value: Error, incorrect string value

Post by dm-m » Fri 20 Nov 2020 13:42

Hello,

Thank you for posting on our Devart forums!

Please set 'True' for Unicode parameter in the Advanced parameters of your MySQL connection:
https://www.screencast.com/t/dxfVhFHSBR

It should fix the error.

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


MarkSabier14
Posts: 3
Joined: Wed 03 Feb 2021 15:06
Location: Atlanta, GA, USA
Contact:

Re: MySQL update row value: Error, incorrect string value

Post by MarkSabier14 » Wed 03 Feb 2021 19:21

BiBo wrote: Mon 01 Feb 2021 11:36 This solution helps me
Thank you so much you really helped me. Strange that I could not find it on Google myself :)

Post Reply