# SQL

### <span class="mw-headline" id="bkmrk-sql-alter%2Fconvert-0">SQL alter/convert</span>

- таблицу и поля в кодировки

`ALTER TABLE `DATABASE`.`TABLE` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;`

- базу, таблицы, поля в кодировки

`ALTER DATABASE `DATABASE` DEFAULT CHARSET=utf8 COLLATE utf8_bin;`

[https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8#6115705](https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8#6115705)

> Use the ALTER DATABASE and ALTER TABLE commands.
> 
> ```
> ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
> ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
> ```
> 
> Or if you're still on MySQL 5.5.2 or older which didn't support 4-byte UTF-8, use utf8 instead of utf8mb4:
> 
> ```
> ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
> ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
> ```