Error Pymysql.err.DataError: (1406, "Data too long for column ' Gender ' at row 1")

When you create a super user in the Django default admin background ,

Error Pymysql.err.DataError: (1406, "Data too long for column ' Gender ' at row 1") workaround.

The creation process is:

Click the Run manage.py Task on the Tool menu, enter Createsuperuser, run, and follow the prompts to enter your username, email, password, and password confirmation.

The workarounds are:

Press the shortcut key ctr+h in Pycharm to find the appropriate field for gender.

　　

We can see that the set gender character length is 5, but female has 6 bytes, so modify max_length=10

Then run:

Makemigrations Users

Run again:

Migrate Users

If there's a problem with these two orders, you can look here.

Then we'll go over it again. The creation process is OK.

Error Pymysql.err.DataError: (1406, "Data too long for column ' Gender ' at row 1")