MySQL_Connector_Arduino icon indicating copy to clipboard operation
MySQL_Connector_Arduino copied to clipboard

The Chinese characters in the mysql database are garbled

Open Mr-Cheung094 opened this issue 2 years ago • 3 comments

hello The Chinese data I read using esp8266 is garbled。The rest of the data is normal。Is there anything you can do about that。 Thank you for answering my question.

image

Mr-Cheung094 avatar Feb 13 '23 09:02 Mr-Cheung094

Hi,

The problem may be character set issues. There is no logic in the connector to support multi-byte character sets. That may be the issue. I might suggest a test with a sample table in another character set to see if that is the issue.

Dr. Bell

On Mon, Feb 13, 2023 at 04:00 Mr. Cheung @.***> wrote:

hello The Chinese data I read using esp8266 is garbled。The rest of the data is normal。Is there anything you can do about that。 Thank you for answering my question.

— Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/203, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYFDQAJP3G3LL64QKHLWXHZ4PANCNFSM6AAAAAAUZ7QUMA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

ChuckBell avatar Feb 13 '23 16:02 ChuckBell

Hi. Any luck with this so far? Let me know if I can help. Dr. Bell

On Feb 13, 2023, at 11:46 AM, Charles Bell @.***> wrote:

Hi,

The problem may be character set issues. There is no logic in the connector to support multi-byte character sets. That may be the issue. I might suggest a test with a sample table in another character set to see if that is the issue.

Dr. Bell

On Mon, Feb 13, 2023 at 04:00 Mr. Cheung @.*** @.***>> wrote:

hello The Chinese data I read using esp8266 is garbled。The rest of the data is normal。Is there anything you can do about that。 Thank you for answering my question.

— Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/203, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYFDQAJP3G3LL64QKHLWXHZ4PANCNFSM6AAAAAAUZ7QUMA. You are receiving this because you are subscribed to this thread.

ChuckBell avatar Feb 17 '23 18:02 ChuckBell

So far, I haven't solved the problem, but I have replaced the Chinese name with the English name

Mr-Cheung094 avatar Feb 22 '23 10:02 Mr-Cheung094