Android Question Error insert data with emoji - B4A + JRDC + MYSQL

[PumaCyan]

I'm creating a form which contains a list of comments...

there are several types of data displayed containing emojis...

the process of displaying it there is no problem, but during the data insert process there are obstacles such as the following :

how to fix it ?

 

[jahswant]

Change data type to utf8mb4 for that field.

 

[PumaCyan]

Change data type to utf8mb4 for that field.

I've used it, but it's still the same problem

 

[aeric]

After you made the change, update the data again.

[B4J] [MySQL] [API] Server (Key + Token) and [B4X] User Login Apps

Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server implements user...

www.b4x.com

 

[PumaCyan]

After you made the change, update the data again.

[B4J] [MySQL] [API] Server (Key + Token) and [B4X] User Login Apps

Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server implements user...

www.b4x.com

I'm almost frustrated by this..

everything related to the database is set up well, even from the start when I use PHP webservices as a bridge client application...

after I searched deeper, I made a mistake by using an old version of the mysql connector library on the JRDC...
very trivial isn't it? ?

after I replaced it with a newer version, everything worked as expected...

thank you very much @jahswant and @aeric

My Reference #1
My Reference #2

 

[aeric]

I'm almost frustrated by this..

everything related to the database is set up well, even from the start when I use PHP webservices as a bridge client application...

after I searched deeper, I made a mistake by using an old version of the mysql connector library on the JRDC...
very trivial isn't it? ?

after I replaced it with a newer version, everything worked as expected...

thank you very much @jahswant and @aeric

My Reference #1
My Reference #2

Yes, sometimes using a more recent version of database driver solves the issue. This kind of issue I also faced before in SQLite.