Forums

hi I want to save emojis in my database, so I should change DB Unicode from utf8 to utf8mb4.I found this topic but when I want to use below code

ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

it makes below error:

ERROR 1146 (42S02): Table 'khadamat$default.users' doesn't exist

anyone have experienced how to save emoji in MySQL database or know where are the problems. thanks.

The problem is that the table does not exist. It has nothing to do with which particular character set you're trying to use. You just can't do anything to a table that doesn't exist. Make sure you're using the right table name.