By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Table | Create Table |
---|---|
test | CREATE TABLE `test` ( `column1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `column2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
column1 | 766172636861722832353529 | utf8mb4_general_ci | YES | null | select,insert,update,references | |||
column2 | 766172636861722832353529 | utf8mb4_unicode_ci | YES | null | select,insert,update,references |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
column1 | 766172636861722832353529 | utf8mb4_unicode_ci | YES | null | select,insert,update,references | |||
column2 | 766172636861722832353529 | utf8mb4_unicode_ci | YES | null | select,insert,update,references |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
column1 | 766172636861722832353529 | latin1_swedish_ci | YES | null | select,insert,update,references | |||
column2 | 766172636861722832353529 | latin1_general_ci | YES | null | select,insert,update,references |