How to change the encoding in the database?

A

Alexander Konovalov2014-05-30 23:39:53

MySQL

Alexander Konovalov, 2014-05-30 23:39:53

How to change encoding in phpmyadmin database to utf-8?
SET NAMES doesn't help.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

Maxim E, 2014-06-01
@Huf

After moving from one hosting to another, there was a problem: the output of question marks instead of Cyrillic. Decided like this in the output (php file):

mysql_query("SET NAMES cp1251");
mysql_query("SET COLLATION_CONNECTION=cp_1251");

M

Mykola, 2014-05-30
@iSensetivity

ALTER TABLE `TABLE` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci