utf8mb4 ?

632 posts
BubikolRamios's profile image BubikolRamios posted 9 years ago in General Permalink 
/* SQL Error (2013): Lost connection to MySQL server during query */
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 0 of 1 query: 0,000 sec. */
/* Connection to host closed at 2015-08-21 11:26:19 */
/* Connecting to host  via MySQL (TCP/IP), username un, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 225 */
/* Unknown character set: 'utf8mb4' */
/* Characterset: utf8 */
10 posts
[expired user #9138]'s profile image [expired user #9138] posted 9 years ago Permalink
Read the solution of this thread: http://stackoverflow.com/questions/21911733/error-1115-42000-unknown-character-set-utf8mb4-in-mysql
632 posts
BubikolRamios's profile image BubikolRamios posted 9 years ago Permalink
quote from there:
you set a certain character set in your code, but your mysql version does not support it

It is certain that I newer set utf8mb4 anywhere in my db, since I newer heard abot utf8mb4 before this error. If i do, I do set UTF8.

I gues heidi SQL is generating those messages ...
632 posts
BubikolRamios's profile image BubikolRamios posted 9 years ago Permalink
hmm, if separately run:

SELECT CONNECTION_ID();
/* Affected rows: 0  Found rows: 1  Warnings: 0  Duration for 1 query: 0,031 sec. */

where and what is this warning ?
10361 posts
ansgar's profile image ansgar posted 9 years ago Permalink
Newer HeidiSQL versions use the fixed utf8mb4 charset, if the server supports that. If not available, utf8 is used. See this thread.
10 posts
[expired user #9138]'s profile image [expired user #9138] posted 9 years ago Permalink

Newer HeidiSQL versions use the fixed utf8mb4 charset, if the server supports that. If not available, utf8 is used. See this thread.


I am agree with ansgar.

Please login to leave a reply, or register at first.