0

i want to change the character set of a table in mysql database to utf8mb4 without changing in config file .i dont want entire database to use utf8mb4 .

i already changed the database,table and procedures character set and collation to utf8mb4 

alter database DBNAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table tblname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

i want to store emojis in mysql databse without changing the entire database to utf8mb4 .please help me

Derviş Kayımbaşıoğlu
  • 28,492
  • 4
  • 50
  • 72
user2623775
  • 23
  • 5
  • Anywhere you want to store emoji type characters you'll need to convert it. – tadman Jan 10 '19 at 15:58
  • hi @tadman can you help me out necessary step in details .even after converting character set i am unable to store – user2623775 Jan 11 '19 at 06:11
  • That really doesn't tell us where the problem is. The list of necessary steps starts with giving us something to work with, like an error or *anything* that helps narrow down the problem. – tadman Jan 11 '19 at 06:12
  • @tadman even after doing this commands alter database DBNAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; alter table tblname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; after changing the charcter set of procedures involved to utf8mb4 does not solve the issue . what else required ? – user2623775 Jan 11 '19 at 06:15
  • Even after doing that...what? It's important to explain what you're seeing, because we can only guess otherwise. – tadman Jan 11 '19 at 06:16
  • @tadman i am getting ???? in database instead of emojis – user2623775 Jan 11 '19 at 06:19
  • Unless you can describe this in terms we can reproduce, I've got no idea what you're asking for. What emojis? How are you inserting them? Are you sure you're using UTF-8? – tadman Jan 11 '19 at 06:19
  • @tadman may i know what exact information you need to help me out ? – user2623775 Jan 11 '19 at 06:36
  • #1 is an error message. #2 is some SQL that reproduces the problem you have *including* how you're trying to insert. – tadman Jan 11 '19 at 16:22

0 Answers0