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

PumaCyan

Member
Licensed User
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 :

bug1.png


how to fix it ?
 
Solution
After you made the change, update the data again.


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

Expert
Licensed User
Longtime User
After you made the change, update the data again.

 
Last edited:
Upvote 0

PumaCyan

Member
Licensed User
After you made the change, update the data again.


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
 
Upvote 1
Solution

aeric

Expert
Licensed User
Longtime User
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.
 
Upvote 0
Top