Support forum
Add Reply
Add Topic4:15 pm
May 28, 2013
Offline
QuoteHello 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.
1 Guest(s)