Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

MySql/ODBC - Server does not support 4-byte encoded UTF8
sp_NewPost Add Reply sp_NewTopic Add Topic
October 22, 2012
6:12 pm

I rolled back to MySql ODBC 3.51 and it immediately started working.

October 16, 2012
3:52 pm
Henk Helmantel

Update: For the customer I mentioned, the solution was to install the 32-bit version of the MySQL ODBC driver version 5.1.8.

October 9, 2012
8:32 pm
Henk Helmantel

Hi Maurizio,

We have never seen this error ourselves but I have received a report from a customer with the same error message. His solution was to install a different version of the MySQL ODBC driver. Unfortunately, I don't know the specifics of the solution.

MySQL does not support the full UTF8 character set, 4-byte characters are not allowed. However, SMS only supports 16-bits Unicode which translates to 1-3 bytes UTF8 encoding so this should never be a problem because Diafaan SMS Server will never generate a 4 byte UTF8 character.

Regards, Henk

October 9, 2012
1:09 pm

already deployed several installations.

This time (WinXP 32 bit, MySql 5.1.6, MysQlOdbc conn. 5.2(w)) I get into a weird problem.
If the sending table is empty, the server is "Ready to send messages".
As soon as I insert one record in the table, the server complains about "SQL Server error".

I just have one only error row in the EVENT LOG:
ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.36-community]Server does not support 4-byte encoded UTF8 characters.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502