How to change mysql db encoding from latin1_swedish

P

Paka2018-02-09 10:09:34

MySQL

Paka, 2018-02-09 10:09:34

How to change mysql db encoding from latin1_swedish_ci to utf8?

There is a database with latin1_swedish_ci encoding, but the data inside is in utf8 encoding.
Because of this, pma shows data in an unreadable form.
How to be?
PS database size 1 GB

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

My joy, 2018-02-09
@t-alexashka

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

did you try that?