Android Question Help for uploading MySQL database garbled code problem，thank you!

[bskotu555]

How to handle the situation where the variable nc contains Chinese characters and becomes garbled after uploading to the database?

 

[Erel]

Please post code as text with code tags.

 

[teddybear]

At post #2 and #5 of this thread, you have been told how to post code. you should read the Forum Guidelines and the "Code Smells" first.

The character set of the mysql server is incorrect, try to change it to utf8mb4

​

​

 

[bskotu555]

Please post code as text with code tags.

I can manually input Chinese characters into the database, but inserting Chinese characters into the database using B4A will result in garbled characters. I am wondering if I need to transcode them during the insertion process or not?

 

[bskotu555]

At post #2 and #5 of this thread, you have been told how to post code. you should read the Forum Guidelines and the "Code Smells" first.

The character set of the mysql server is incorrect, try to change it to utf8mb4

​

​

At post #2 and #5 of this thread, you have been told how to post code. you should read the Forum Guidelines and the "Code Smells" first.

The character set of the mysql server is incorrect, try to change it to utf8mb4

​

​

Dim cx As Int =EditText1.text'ID
        Dim nc As String=EditText2.Text'昵称
        Dim tx As String=EditText3.Text'内容
        sqlstr = "insert into chat(ChatID,Nickname,Text,time) values('" & cx & "','" & nc & "','" & tx & "','" & DateTime.Date(DateTime.Now) & "')"
        Starter.Mysql_Jdbc.ExecNonQuery(sqlstr)

 

[bskotu555]

It has been resolved. Just change the character set of the database to GB2312！