🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
information_schema
Nivel actual
🧬 Columnas: information_schema / COLLATIONS
7| Campo | Tipo | Null | Key | Default | Extra |
|---|
| COLLATION_NAME | varchar(64) | NO | | | |
| CHARACTER_SET_NAME | varchar(32) | YES | | | |
| ID | bigint(11) | YES | | | |
| IS_DEFAULT | varchar(3) | YES | | | |
| IS_COMPILED | varchar(3) | NO | | | |
| SORTLEN | bigint(3) | NO | | | |
| COMMENT | varchar(80) | NO | | | |
🔬 Muestra de datos
20 filas
| COLLATION_NAME | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN | COMMENT |
|---|
| big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | Big5 Traditional Chinese |
| big5_bin | big5 | 84 | | Yes | 1 | Big5 Traditional Chinese |
| big5_chinese_nopad_ci | big5 | 1025 | | Yes | 1 | |
| big5_nopad_bin | big5 | 1108 | | Yes | 1 | |
| dec8_swedish_ci | dec8 | 3 | Yes | Yes | 1 | DEC West European |
| dec8_bin | dec8 | 69 | | Yes | 1 | DEC West European |
| dec8_swedish_nopad_ci | dec8 | 1027 | | Yes | 1 | DEC West European |
| dec8_nopad_bin | dec8 | 1093 | | Yes | 1 | DEC West European |
| cp850_general_ci | cp850 | 4 | Yes | Yes | 1 | DOS West European |
| cp850_bin | cp850 | 80 | | Yes | 1 | DOS West European |
| cp850_general_nopad_ci | cp850 | 1028 | | Yes | 1 | DOS West European |
| cp850_nopad_bin | cp850 | 1104 | | Yes | 1 | DOS West European |
| hp8_english_ci | hp8 | 6 | Yes | Yes | 1 | HP West European |
| hp8_bin | hp8 | 72 | | Yes | 1 | HP West European |
| hp8_english_nopad_ci | hp8 | 1030 | | Yes | 1 | HP West European |
| hp8_nopad_bin | hp8 | 1096 | | Yes | 1 | HP West European |
| koi8r_general_ci | koi8r | 7 | Yes | Yes | 1 | KOI8-R Relcom Russian |
| koi8r_bin | koi8r | 74 | | Yes | 1 | KOI8-R Relcom Russian |
| koi8r_general_nopad_ci | koi8r | 1031 | | Yes | 1 | KOI8-R Relcom Russian |
| koi8r_nopad_bin | koi8r | 1098 | | Yes | 1 | KOI8-R Relcom Russian |