alter database collate utf8_hungarian_ci;

ALTER TABLE munkakozosseg CONVERT TO character set utf8 collate utf8_hungarian_ci;
ALTER TABLE osztaly CONVERT TO character set utf8 COLLATE utf8_hungarian_ci;
ALTER TABLE tanar CONVERT TO character set utf8 COLLATE utf8_hungarian_ci;
ALTER TABLE terem CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE szemeszter CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE idoszak 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE targy 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE szulo 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE diak 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE mkTanar
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE osztalyDiak 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE osztalyTanar
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE zaroJegy 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE hianyzasOsszesites
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE tankor 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE tankorDiak
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE tankorSzemeszter
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE tankorOsztaly 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE tankorTanar 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE uzenet
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE uzen 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE kepzes 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE kepzesDiak 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE kepzesOsztaly
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE kepzesTargyOraszam 
CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;

ALTER TABLE kepzesOraszam CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;