Support forum
Hello Wayne,
It can sometimes be a challenge to get the MySQL database/ODBC driver combination to work together perfectly with Unicode strings. There is usually a combination of the database and driver that works correctly but I find it easier to use the MariaDB ODBC driver instead. This driver sometimes solves other (minor) compatibility problems between MySQL server and the ODBC driver as well.
Regards, Henk
12:31 pm
Hi
We recently changed from using ms access to mysql database and started getting a few errors.
[mysqld-8.0.22]Incorrect string value: '\xF0\x9F\xA4\xA9' for column 'MsgBody' at row 1
[mysqld-8.0.22]Conversion from collation utf8_general_ci into utf8mb4_unicode_ci impossible for parameter
the connection string to the database is:
Driver={MySQL ODBC 8.0 UNICODE Driver};Server=xxxx;port=xxxx;charset=UTF8MB4;Database=xxxx;User=xxxx;Password=xxxx;Option=3;
Database was utf8mb4 charatcer set with collation utf8mb4_unicode_ci changed the collation to utf8mb4_general_ci that got rid of the conversion error but now getting the incorrect string value.
Looks like we only see this error when we receive emojis in the sms.
Most Users Ever Online: 529
Currently Online:
2 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 681
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1160
Posts: 3962
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1518