Default Character Set =utf8
The database was created to specify a character set.
Create default character set utf8 of database mydb and proofread utf8_general_ci
To create a data representation, you also need to specify a character set:
Wrong command:
If it does not exist, create a table mydb (
Username' varchar(64) is not empty.
Userid' int( 1 1) is not empty.
)ENGINE = InnoDB DEFAULT CHARSET = Latin 1;
Correct command:
If it does not exist, create a table mydb (
Username' varchar(64) is not empty.
Userid' int( 1 1) is not empty.
)ENGINE = InnoDB DEFAULT CHARSET = utf8;