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?