Vowels character encoding issue fixing (charset)

vowel-charac-encoding-fix.md

• DataBase > Table > Character Set > utf-8
• DataBase > Table > Collation > utf8_general_ci
• Response Headers > Content Type > application/json; charset=utf-8
• [Frontend] Website Application > HTML > charset meta tag > utf-8 => <meta charset="utf-8">
• Database > Table > Column > Correct value
• SQL file > Execution > --default-character-set=utf8

DB Charset & Collation Check

SELECT
	SCHEMA_NAME AS database_name,
	DEFAULT_CHARACTER_SET_NAME,
	DEFAULT_COLLATION_NAME
FROM
	INFORMATION_SCHEMA.SCHEMATA
WHERE
	SCHEMA_NAME IN ('someDatabaseName1', 'someDatabaseName2');

Table Charset & Collation

SELECT
	T.table_schema AS database_name,
	T.table_name,
	CCSA.character_set_name,
	CCSA.collation_name
FROM
	information_schema. `TABLES` T,
	information_schema. `COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE
	CCSA.collation_name = T.table_collation
	AND T.table_schema IN ('someDatabaseName1', 'someDatabaseName2')
	AND T.table_name IN ('someTableName1', 'someTableName2', 'someTableName2');

Column Charset & Collation

SELECT
	table_schema AS database_name,
	table_name,
	column_name,
	character_set_name,
	collation_name
FROM
	information_schema. `COLUMNS`
WHERE
	table_schema IN ('someDatabaseName1', 'someDatabaseName2')
	AND table_name IN ('someTableName1', 'someTableName2', 'someTableName2')
	AND column_name IN ('someColumnName1', 'someColumnName2', 'someColumnName3', 'someColumnName4');