The utf8mb4 Is Not Working

[arshidkv12]

The utf8mb4 Is Not Working

[arshidkv12]

It is working if I add the following code (each time).

connection.query("SET CHARACTER SET utf8mb4");
connection.query(
  'INSERT INTO emails ( `subject` )   VALUES (" subject 👋" );',
);

[sidorares]

@arshidkv12 can you try using UTF8MB4_GENERAL_CI as charset value?
I suspect your charset is not recognised. If that's the case we should probably warn users

The reason your second example works is that we track state variables updates and is "CHARACTER SET" variable is updated connection knows that - see

node-mysql2/lib/packets/resultset_header.js

Lines 65 to 68 in 489154f

	if (key === 'character_set_client') {
	const charsetNumber = EncodingToCharset[val];
	connection.config.charsetNumber = charsetNumber;
	}

[arshidkv12]

I attempted the code below, but it didn't work.

var connection = mysql.createConnection({
    host:  config.DB_HOST,
    user:  config.DB_USERNAME,
    password: config.DB_PASSWORD, 
    database: config.DB_DATABASE,
    charset: 'UTF8MB4_GENERAL_CI'
});

OR

var connection = mysql.createConnection({
    host:  config.DB_HOST,
    user:  config.DB_USERNAME,
    password: config.DB_PASSWORD, 
    database: config.DB_DATABASE,
    charsetNumber:45
});

[arshidkv12]

How to fix it? Can I set charsetNumber:45 by hardcode?