search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
332 stars 133 forks source link

The Chinese characters in the mysql database are garbled #203

Open Mr-Cheung094 opened 1 year ago

Mr-Cheung094 commented 1 year ago

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

ChuckBell commented 1 year ago

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 commented 1 year ago

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.

Mr-Cheung094 commented 1 year ago

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