How to get emoji to work with mysql 5.7?

I know this is not Framework7 related, but have anybody made emoji work with db mysql 5.7?
I have search all over and everywhere it says that Im doing the right thing, so I thought that I should try here to see if anybody can help.

Im trying to get emojis to work in with my mysql 5.7 database and .asp pages and all I get is a ? instead of the emoji.

I have set the db and tables to use the right collections etc.

In the mysql my.ini file I have this.

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci

And if I in mysql workbench writes this.

SHOW VARIABLES
WHERE Variable_name
LIKE 'character\_set\_%'
OR Variable_name LIKE 'collation%';

Then I get this

'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8mb4'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'utf8mb4'
'character_set_system', 'utf8'
'collation_connection', 'utf8_general_ci'
'collation_database', 'utf8mb4_general_ci'
'collation_server', 'utf8mb4_unicode_ci'

So client, connection, result are still showing as utf-8.

But if I write this global one then they are utf-8mb4!?

SHOW GLOBAL VARIABLES WHERE Variable_name LIKE 'character\_set\_%' 
OR Variable_name LIKE 'collation%';

'character_set_client', 'utf8mb4'
'character_set_connection', 'utf8mb4'
'character_set_database', 'utf8mb4'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8mb4'
'character_set_server', 'utf8mb4'
'character_set_system', 'utf8'
'collation_connection', 'utf8mb4_unicode_ci'
'collation_database', 'utf8mb4_unicode_ci'
'collation_server', 'utf8mb4_unicode_ci'

Then I connect with this to the db to my pages.

strConn = "driver={MySQL ODBC 5.2 Unicode Driver};server=localhost;uid=test;pwd=test;database=test;option=3;charset=utf8mb4;" 
    set conn = Server.CreateObject("ADODB.Connection")
    conn.Open strConn 

And in my .asp pages I set the charset like this at the top of the page.

Response.charset="utf-8"
Then in mysql workbench I have run the

SET NAMES utf8mb4
to be able to insert an emoji. (I don´t know why I have to use SET NAMES utf8mb4 before I can insert an emoji?)

I have done all this and I still get a ? instead of an emoji.?

So what am I missing? Any input really appreciated, thanks!

Anybody that has done this?

Try to set the Response charset to utf8mb4.

Thanks Frooplet, I have already tested that but still just a ?

Still haven´t been able to sort this out.
Anybody that has worked with emojis and mySql 5.7?