SHOW CHARACTER SET LIKE 'utf%'

show variables like 'char%'

SET character_set_client = cp1250; 
SET character_set_connection = utf8; 
SET character_set_results = latin2;


SELECT @@character_set_database, @@collation_database;

..... CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE xxxx CHARACTER SET utf8 COLLATE utf8_general_ci;
...... SCHEMA  ....

ALTER DATABASE .....  CHARACTER SET utf8 COLLATE utf8_general_ci;


... přiřadit práva