Per vedere:
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS where table_schema = "listini"


per Cambiare:
ALTER DATABASE listini CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
SET foreign_key_checks = 0;
ALTER TABLE specificatecnica CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE dizionariocategoria CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE prodotto CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE prodottolistino CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE prodottocodicefornitore CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE prodottomulticodice CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE prodottospecificatecnica CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
SET foreign_key_checks = 1;