id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29678	"inspectdb fails on MySQL 8 with "" 'utf8' is currently an alias for the character set UTF8MB3"""	SuilAmhain	nobody	"Hi,

I have created a bunch of tables in MySQL 8.0.12 that I wished to import into Django.

But I consistently receive this error when attempting to do so:
{{{
# The error was: (3719, ""3719: 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous."", None)
}}}

The problem is that the information_schema that is queried for table information uses UTF8, which is an an alias of UTF8MB3.

MySQL has introduced a warning from MySQL 8 to encourage you to use UTF8MB4 explicitly. inspectdb cannot deal with that warning.

I appreciate this may be regarded as a MySQL feature/bug. 

Django is running these queries:
{{{
2018-08-15T23:25:41.500932Z	   43 Query	SELECT column_name, referenced_table_name, referenced_column_name FROM information_schema.key_column_usage WHERE table_name = 'django_content_type' AND table_schema = DATABASE() AND referenced_table_name IS NOT NULL AND referenced_column_name IS NOT NULL
2018-08-15T23:25:41.511166Z	   43 Query	SHOW WARNINGS
}}}

The show warnings is the problem. I am very new to Django and cannot workaround it. 









"	Bug	closed	Core (Management commands)	2.1	Normal	invalid			Unreviewed	0	0	0	0	0	0