Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Incorrect String value/Conversion
sp_NewPost Add Reply sp_NewTopic Add Topic
March 2, 2021
4:15 pm
Henk Helmantel
Admin
Forum Posts: 1275
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

March 2, 2021
12:31 pm
Wayne
Guest
Guests

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.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 602

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1001

Posts: 3430

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1275