Page 1 of 1

MySQL update row value: Error, incorrect string value

Posted: Wed 26 Aug 2020 10:27
by BiBo
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.

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

Posted: Wed 18 Nov 2020 10:26
by AlexBrown
It says it does support but actually it doesn't

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

Posted: Fri 20 Nov 2020 13:42
by dm-m
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.

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

Posted: Mon 01 Feb 2021 11:36
by BiBo

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

Posted: Wed 03 Feb 2021 19:21
by MarkSabier14
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 :)