
// try CHARACTER SET utf8 COLLATE utf8_unicode_ci; CHARACTER SET utf8 COLLATE utf8_general_ci;

// charset-coallition engine
    SELECT T.TABLE_NAME,CCSA.character_set_name, T.TABLE_COLLATION,T.ENGINE,T.TABLE_COMMENT 
    FROM information_schema.TABLES T 
         JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA ON CCSA.collation_name = T.table_collation
    WHERE T.table_schema = "tten3"
    ORDER BY T.TABLE_NAME;

//cols en charset/coallition diferente a tabla
SELECT C.column_name,C.DATA_TYPE,C.character_set_name,C.COLLATION_NAME FROM information_schema.COLUMNS C
WHERE C.table_schema = "tten3"
  AND C.table_name = "talento"
  AND C.DATA_TYPE IN ('enum', 'varchar', 'char', 'text', 'mediumtext', 'longtext')
  AND column_name = "columnname";

SELECT TABLE_SCHEMA,
       TABLE_NAME,
       CCSA.CHARACTER_SET_NAME AS DEFAULT_CHAR_SET,
       COLUMN_NAME,
       COLUMN_TYPE,
       C.CHARACTER_SET_NAME
  FROM information_schema.TABLES AS T
  JOIN information_schema.COLUMNS AS C USING (TABLE_SCHEMA, TABLE_NAME)
  JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS CCSA
       ON (T.TABLE_COLLATION = CCSA.COLLATION_NAME)
 WHERE TABLE_SCHEMA=SCHEMA()
   AND C.DATA_TYPE IN ('enum', 'varchar', 'char', 'text', 'mediumtext', 'longtext')
 ORDER BY TABLE_SCHEMA,
          TABLE_NAME,
          COLUMN_NAME

// autoincremtnes-sizes

