IBAN: DE30 2585 0110 0046 0424 20
BIC: NOLADE21UEL
Stichwort: PERRYPEDIA
Institut: SK Uelzen Lüchow-Dannenberg
Kontoinhaber: PERRY RHODAN FAN ZENTRALEDeine Spenden helfen, die Perrypedia zu betreiben.Perrypedia:MySQL-Zeichensätze 11.03.2022
Zur Navigation springen
Zur Suche springen
mysql> SHOW VARIABLES LIKE 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb3 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb3 | | character_set_system | utf8mb3 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0,01 sec) mysql> use ppdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT @@character_set_database, @@collation_database; +--------------------------+----------------------+ | @@character_set_database | @@collation_database | +--------------------------+----------------------+ | utf8mb3 | utf8_general_ci | +--------------------------+----------------------+ 1 row in set (0,00 sec) mysql> select table_name, column_name, data_type, character_set_name, collation_name from information_schema.columns where table_schema='ppdb' order by table_name, column_name; +-----------------------+--------------------------------+------------+--------------------+-------------------+ | TABLE_NAME | COLUMN_NAME | DATA_TYPE | CHARACTER_SET_NAME | COLLATION_NAME | +-----------------------+--------------------------------+------------+--------------------+-------------------+ | actor | actor_id | bigint | NULL | NULL | | actor | actor_name | varbinary | NULL | NULL | | actor | actor_user | int | NULL | NULL | | ajaxpoll_info | poll_date | datetime | NULL | NULL | | ajaxpoll_info | poll_id | varchar | utf8 | utf8_general_ci | | ajaxpoll_info | poll_txt | text | utf8 | utf8_general_ci | | ajaxpoll_vote | poll_answer | int | NULL | NULL | | ajaxpoll_vote | poll_date | datetime | NULL | NULL | | ajaxpoll_vote | poll_id | varchar | utf8 | utf8_general_ci | | ajaxpoll_vote | poll_ip | varchar | utf8 | utf8_general_ci | | ajaxpoll_vote | poll_user | varchar | utf8 | utf8_general_ci | | archive | ar_actor | bigint | NULL | NULL | | archive | ar_comment_id | bigint | NULL | NULL | | archive | ar_deleted | tinyint | NULL | NULL | | archive | ar_id | int | NULL | NULL | | archive | ar_len | int | NULL | NULL | | archive | ar_minor_edit | tinyint | NULL | NULL | | archive | ar_namespace | int | NULL | NULL | | archive | ar_page_id | int | NULL | NULL | | archive | ar_parent_id | int | NULL | NULL | | archive | ar_rev_id | int | NULL | NULL | | archive | ar_sha1 | varbinary | NULL | NULL | | archive | ar_timestamp | varchar | latin1 | latin1_bin | | archive | ar_title | varchar | latin1 | latin1_bin | | bot_passwords | bp_app_id | varbinary | NULL | NULL | | bot_passwords | bp_grants | blob | NULL | NULL | | bot_passwords | bp_password | tinyblob | NULL | NULL | | bot_passwords | bp_restrictions | blob | NULL | NULL | | bot_passwords | bp_token | binary | NULL | NULL | | bot_passwords | bp_user | int | NULL | NULL | | category | cat_files | int | NULL | NULL | | category | cat_id | int | NULL | NULL | | category | cat_pages | int | NULL | NULL | | category | cat_subcats | int | NULL | NULL | | category | cat_title | varchar | latin1 | latin1_bin | | categorylinks | cl_collation | varbinary | NULL | NULL | | categorylinks | cl_from | int | NULL | NULL | | categorylinks | cl_sortkey | varbinary | NULL | NULL | | categorylinks | cl_sortkey_prefix | varchar | latin1 | latin1_bin | | categorylinks | cl_timestamp | timestamp | NULL | NULL | | categorylinks | cl_to | varchar | latin1 | latin1_bin | | categorylinks | cl_type | enum | latin1 | latin1_swedish_ci | | change_tag | ct_id | int | NULL | NULL | | change_tag | ct_log_id | int | NULL | NULL | | change_tag | ct_params | blob | NULL | NULL | | change_tag | ct_rc_id | int | NULL | NULL | | change_tag | ct_rev_id | int | NULL | NULL | | change_tag | ct_tag_id | int | NULL | NULL | | change_tag_def | ctd_count | bigint | NULL | NULL | | change_tag_def | ctd_id | int | NULL | NULL | | change_tag_def | ctd_name | varbinary | NULL | NULL | | change_tag_def | ctd_user_defined | tinyint | NULL | NULL | | chat | chat_message | text | utf8 | utf8_general_ci | | chat | chat_timestamp | bigint | NULL | NULL | | chat | chat_to_id | int | NULL | NULL | | chat | chat_type | int | NULL | NULL | | chat | chat_user_id | int | NULL | NULL | | chat_users | cu_away | binary | NULL | NULL | | chat_users | cu_timestamp | binary | NULL | NULL | | chat_users | cu_user_id | int | NULL | NULL | | comment | comment_data | blob | NULL | NULL | | comment | comment_hash | int | NULL | NULL | | comment | comment_id | bigint | NULL | NULL | | comment | comment_text | blob | NULL | NULL | | content | content_address | varbinary | NULL | NULL | | content | content_id | bigint | NULL | NULL | | content | content_model | smallint | NULL | NULL | | content | content_sha1 | varbinary | NULL | NULL | | content | content_size | int | NULL | NULL | | content_models | model_id | smallint | NULL | NULL | | content_models | model_name | varbinary | NULL | NULL | | cu_changes | cuc_actiontext | varchar | utf8 | utf8_bin | | cu_changes | cuc_agent | varchar | utf8 | utf8_bin | | cu_changes | cuc_comment | varchar | utf8 | utf8_bin | | cu_changes | cuc_id | int | NULL | NULL | | cu_changes | cuc_ip | varchar | utf8 | utf8_general_ci | | cu_changes | cuc_ip_hex | varchar | utf8 | utf8_general_ci | | cu_changes | cuc_last_oldid | int | NULL | NULL | | cu_changes | cuc_minor | tinyint | NULL | NULL | | cu_changes | cuc_namespace | int | NULL | NULL | | cu_changes | cuc_page_id | int | NULL | NULL | | cu_changes | cuc_private | mediumblob | NULL | NULL | | cu_changes | cuc_this_oldid | int | NULL | NULL | | cu_changes | cuc_timestamp | char | utf8 | utf8_general_ci | | cu_changes | cuc_title | varchar | utf8 | utf8_bin | | cu_changes | cuc_type | tinyint | NULL | NULL | | cu_changes | cuc_user | int | NULL | NULL | | cu_changes | cuc_user_text | varchar | utf8 | utf8_general_ci | | cu_changes | cuc_xff | varchar | utf8 | utf8_bin | | cu_changes | cuc_xff_hex | varchar | utf8 | utf8_general_ci | | cu_log | cul_id | int | NULL | NULL | | cu_log | cul_range_end | varbinary | NULL | NULL | | cu_log | cul_range_start | varbinary | NULL | NULL | | cu_log | cul_reason | varchar | utf8 | utf8_bin | | cu_log | cul_target_hex | varbinary | NULL | NULL | | cu_log | cul_target_id | int | NULL | NULL | | cu_log | cul_target_text | blob | NULL | NULL | | cu_log | cul_timestamp | binary | NULL | NULL | | cu_log | cul_type | varbinary | NULL | NULL | | cu_log | cul_user | int | NULL | NULL | | cu_log | cul_user_text | varchar | utf8 | utf8_bin | | external_user | eu_external_id | varchar | latin1 | latin1_bin | | external_user | eu_local_id | int | NULL | NULL | | externallinks | el_from | int | NULL | NULL | | externallinks | el_id | int | NULL | NULL | | externallinks | el_index | blob | NULL | NULL | | externallinks | el_index_60 | varbinary | NULL | NULL | | externallinks | el_to | blob | NULL | NULL | | favoritelist | fl_namespace | int | NULL | NULL | | favoritelist | fl_notificationtimestamp | varbinary | NULL | NULL | | favoritelist | fl_title | varbinary | NULL | NULL | | favoritelist | fl_user | int | NULL | NULL | | filearchive | fa_actor | bigint | NULL | NULL | | filearchive | fa_archive_name | varchar | latin1 | latin1_bin | | filearchive | fa_bits | int | NULL | NULL | | filearchive | fa_deleted | tinyint | NULL | NULL | | filearchive | fa_deleted_reason_id | bigint | NULL | NULL | | filearchive | fa_deleted_timestamp | varchar | latin1 | latin1_bin | | filearchive | fa_deleted_user | int | NULL | NULL | | filearchive | fa_description_id | bigint | NULL | NULL | | filearchive | fa_height | int | NULL | NULL | | filearchive | fa_id | int | NULL | NULL | | filearchive | fa_major_mime | enum | latin1 | latin1_swedish_ci | | filearchive | fa_media_type | enum | latin1 | latin1_swedish_ci | | filearchive | fa_metadata | mediumblob | NULL | NULL | | filearchive | fa_minor_mime | varbinary | NULL | NULL | | filearchive | fa_name | varchar | latin1 | latin1_bin | | filearchive | fa_sha1 | varbinary | NULL | NULL | | filearchive | fa_size | int | NULL | NULL | | filearchive | fa_storage_group | varchar | latin1 | latin1_swedish_ci | | filearchive | fa_storage_key | varchar | latin1 | latin1_bin | | filearchive | fa_timestamp | varchar | latin1 | latin1_bin | | filearchive | fa_width | int | NULL | NULL | | flow_ext_ref | ref_id | binary | NULL | NULL | | flow_ext_ref | ref_src_namespace | int | NULL | NULL | | flow_ext_ref | ref_src_object_id | binary | NULL | NULL | | flow_ext_ref | ref_src_object_type | varbinary | NULL | NULL | | flow_ext_ref | ref_src_title | varbinary | NULL | NULL | | flow_ext_ref | ref_src_wiki | varchar | utf8 | utf8_bin | | flow_ext_ref | ref_src_workflow_id | binary | NULL | NULL | | flow_ext_ref | ref_target | blob | NULL | NULL | | flow_ext_ref | ref_type | varbinary | NULL | NULL | | flow_revision | rev_change_type | varbinary | NULL | NULL | | flow_revision | rev_content | mediumblob | NULL | NULL | | flow_revision | rev_content_length | int | NULL | NULL | | flow_revision | rev_edit_user_id | bigint | NULL | NULL | | flow_revision | rev_edit_user_ip | varbinary | NULL | NULL | | flow_revision | rev_edit_user_wiki | varchar | utf8 | utf8_bin | | flow_revision | rev_flags | tinyblob | NULL | NULL | | flow_revision | rev_id | binary | NULL | NULL | | flow_revision | rev_last_edit_id | binary | NULL | NULL | | flow_revision | rev_mod_reason | varchar | utf8 | utf8_bin | | flow_revision | rev_mod_state | varchar | utf8 | utf8_bin | | flow_revision | rev_mod_timestamp | varchar | utf8 | utf8_bin | | flow_revision | rev_mod_user_id | bigint | NULL | NULL | | flow_revision | rev_mod_user_ip | varbinary | NULL | NULL | | flow_revision | rev_mod_user_wiki | varchar | utf8 | utf8_bin | | flow_revision | rev_parent_id | binary | NULL | NULL | | flow_revision | rev_previous_content_length | int | NULL | NULL | | flow_revision | rev_type | varchar | utf8 | utf8_bin | | flow_revision | rev_type_id | binary | NULL | NULL | | flow_revision | rev_user_id | bigint | NULL | NULL | | flow_revision | rev_user_ip | varbinary | NULL | NULL | | flow_revision | rev_user_wiki | varchar | utf8 | utf8_bin | | flow_topic_list | topic_id | binary | NULL | NULL | | flow_topic_list | topic_list_id | binary | NULL | NULL | | flow_tree_node | tree_ancestor_id | binary | NULL | NULL | | flow_tree_node | tree_depth | smallint | NULL | NULL | | flow_tree_node | tree_descendant_id | binary | NULL | NULL | | flow_tree_revision | tree_orig_user_id | bigint | NULL | NULL | | flow_tree_revision | tree_orig_user_ip | varbinary | NULL | NULL | | flow_tree_revision | tree_orig_user_wiki | varchar | utf8 | utf8_bin | | flow_tree_revision | tree_parent_id | binary | NULL | NULL | | flow_tree_revision | tree_rev_descendant_id | binary | NULL | NULL | | flow_tree_revision | tree_rev_id | binary | NULL | NULL | | flow_wiki_ref | ref_id | binary | NULL | NULL | | flow_wiki_ref | ref_src_namespace | int | NULL | NULL | | flow_wiki_ref | ref_src_object_id | binary | NULL | NULL | | flow_wiki_ref | ref_src_object_type | varbinary | NULL | NULL | | flow_wiki_ref | ref_src_title | varbinary | NULL | NULL | | flow_wiki_ref | ref_src_wiki | varchar | utf8 | utf8_bin | | flow_wiki_ref | ref_src_workflow_id | binary | NULL | NULL | | flow_wiki_ref | ref_target_namespace | int | NULL | NULL | | flow_wiki_ref | ref_target_title | varbinary | NULL | NULL | | flow_wiki_ref | ref_type | varbinary | NULL | NULL | | flow_workflow | workflow_id | binary | NULL | NULL | | flow_workflow | workflow_last_update_timestamp | binary | NULL | NULL | | flow_workflow | workflow_lock_state | int | NULL | NULL | | flow_workflow | workflow_name | varchar | utf8 | utf8_bin | | flow_workflow | workflow_namespace | int | NULL | NULL | | flow_workflow | workflow_page_id | int | NULL | NULL | | flow_workflow | workflow_title_text | varchar | utf8 | utf8_bin | | flow_workflow | workflow_type | varbinary | NULL | NULL | | flow_workflow | workflow_wiki | varchar | utf8 | utf8_bin | | image | img_actor | bigint | NULL | NULL | | image | img_bits | int | NULL | NULL | | image | img_description_id | bigint | NULL | NULL | | image | img_height | int | NULL | NULL | | image | img_major_mime | enum | latin1 | latin1_swedish_ci | | image | img_media_type | enum | latin1 | latin1_swedish_ci | | image | img_metadata | mediumblob | NULL | NULL | | image | img_minor_mime | varbinary | NULL | NULL | | image | img_name | varchar | latin1 | latin1_bin | | image | img_sha1 | varbinary | NULL | NULL | | image | img_size | int | NULL | NULL | | image | img_timestamp | varchar | latin1 | latin1_bin | | image | img_width | int | NULL | NULL | | imagelinks | il_from | int | NULL | NULL | | imagelinks | il_from_namespace | int | NULL | NULL | | imagelinks | il_to | varchar | latin1 | latin1_bin | | imagelinks_old | il_from | varchar | latin1 | latin1_bin | | imagelinks_old | il_to | varchar | latin1 | latin1_bin | | interwiki | iw_api | blob | NULL | NULL | | interwiki | iw_local | tinyint | NULL | NULL | | interwiki | iw_prefix | char | latin1 | latin1_swedish_ci | | interwiki | iw_trans | tinyint | NULL | NULL | | interwiki | iw_url | char | latin1 | latin1_swedish_ci | | interwiki | iw_wikiid | varchar | latin1 | latin1_swedish_ci | | ip_changes | ipc_hex | varbinary | NULL | NULL | | ip_changes | ipc_rev_id | int | NULL | NULL | | ip_changes | ipc_rev_timestamp | binary | NULL | NULL | | ipblocks | ipb_address | tinyblob | NULL | NULL | | ipblocks | ipb_allow_usertalk | tinyint | NULL | NULL | | ipblocks | ipb_anon_only | tinyint | NULL | NULL | | ipblocks | ipb_auto | tinyint | NULL | NULL | | ipblocks | ipb_block_email | tinyint | NULL | NULL | | ipblocks | ipb_by | int | NULL | NULL | | ipblocks | ipb_by_actor | bigint | NULL | NULL | | ipblocks | ipb_by_text | varchar | latin1 | latin1_bin | | ipblocks | ipb_create_account | tinyint | NULL | NULL | | ipblocks | ipb_deleted | tinyint | NULL | NULL | | ipblocks | ipb_enable_autoblock | tinyint | NULL | NULL | | ipblocks | ipb_expiry | varchar | latin1 | latin1_bin | | ipblocks | ipb_id | int | NULL | NULL | | ipblocks | ipb_parent_block_id | int | NULL | NULL | | ipblocks | ipb_range_end | tinyblob | NULL | NULL | | ipblocks | ipb_range_start | tinyblob | NULL | NULL | | ipblocks | ipb_reason_id | bigint | NULL | NULL | | ipblocks | ipb_sitewide | tinyint | NULL | NULL | | ipblocks | ipb_timestamp | varchar | latin1 | latin1_bin | | ipblocks | ipb_user | int | NULL | NULL | | ipblocks_old | ipb_address | varchar | latin1 | latin1_bin | | ipblocks_old | ipb_auto | tinyint | NULL | NULL | | ipblocks_old | ipb_by | int | NULL | NULL | | ipblocks_old | ipb_expiry | varchar | latin1 | latin1_bin | | ipblocks_old | ipb_id | int | NULL | NULL | | ipblocks_old | ipb_range_end | varchar | latin1 | latin1_swedish_ci | | ipblocks_old | ipb_range_start | varchar | latin1 | latin1_swedish_ci | | ipblocks_old | ipb_reason | tinyblob | NULL | NULL | | ipblocks_old | ipb_timestamp | varchar | latin1 | latin1_bin | | ipblocks_old | ipb_user | int | NULL | NULL | | ipblocks_restrictions | ir_ipb_id | int | NULL | NULL | | ipblocks_restrictions | ir_type | tinyint | NULL | NULL | | ipblocks_restrictions | ir_value | int | NULL | NULL | | iwlinks | iwl_from | int | NULL | NULL | | iwlinks | iwl_prefix | varbinary | NULL | NULL | | iwlinks | iwl_title | varchar | utf8 | utf8_bin | | job | job_attempts | int | NULL | NULL | | job | job_cmd | varchar | latin1 | latin1_swedish_ci | | job | job_id | int | NULL | NULL | | job | job_namespace | int | NULL | NULL | | job | job_params | mediumblob | NULL | NULL | | job | job_random | int | NULL | NULL | | job | job_sha1 | varbinary | NULL | NULL | | job | job_timestamp | varbinary | NULL | NULL | | job | job_title | varchar | latin1 | latin1_bin | | job | job_token | varbinary | NULL | NULL | | job | job_token_timestamp | varbinary | NULL | NULL | | l10n_cache | lc_key | varchar | latin1 | latin1_swedish_ci | | l10n_cache | lc_lang | varbinary | NULL | NULL | | l10n_cache | lc_value | mediumblob | NULL | NULL | | langlinks | ll_from | int | NULL | NULL | | langlinks | ll_lang | varbinary | NULL | NULL | | langlinks | ll_title | varchar | latin1 | latin1_bin | | log_search | ls_field | varbinary | NULL | NULL | | log_search | ls_log_id | int | NULL | NULL | | log_search | ls_value | varchar | latin1 | latin1_swedish_ci | | logging | log_action | varbinary | NULL | NULL | | logging | log_actor | bigint | NULL | NULL | | logging | log_comment_id | bigint | NULL | NULL | | logging | log_deleted | tinyint | NULL | NULL | | logging | log_id | int | NULL | NULL | | logging | log_namespace | int | NULL | NULL | | logging | log_page | int | NULL | NULL | | logging | log_params | blob | NULL | NULL | | logging | log_timestamp | varchar | latin1 | latin1_swedish_ci | | logging | log_title | varchar | latin1 | latin1_bin | | logging | log_type | varbinary | NULL | NULL | | math | math_html | text | latin1 | latin1_swedish_ci | | math | math_html_conservativeness | tinyint | NULL | NULL | | math | math_inputhash | varchar | latin1 | latin1_swedish_ci | | math | math_mathml | text | latin1 | latin1_swedish_ci | | math | math_outputhash | varchar | latin1 | latin1_swedish_ci | | module_deps | md_deps | mediumblob | NULL | NULL | | module_deps | md_module | varbinary | NULL | NULL | | module_deps | md_skin | varbinary | NULL | NULL | | objectcache | exptime | datetime | NULL | NULL | | objectcache | keyname | varchar | latin1 | latin1_bin | | objectcache | value | mediumblob | NULL | NULL | | oldimage | oi_actor | bigint | NULL | NULL | | oldimage | oi_archive_name | varchar | latin1 | latin1_bin | | oldimage | oi_bits | int | NULL | NULL | | oldimage | oi_deleted | tinyint | NULL | NULL | | oldimage | oi_description_id | bigint | NULL | NULL | | oldimage | oi_height | int | NULL | NULL | | oldimage | oi_major_mime | enum | latin1 | latin1_swedish_ci | | oldimage | oi_media_type | enum | latin1 | latin1_swedish_ci | | oldimage | oi_metadata | mediumblob | NULL | NULL | | oldimage | oi_minor_mime | varbinary | NULL | NULL | | oldimage | oi_name | varchar | latin1 | latin1_bin | | oldimage | oi_sha1 | varbinary | NULL | NULL | | oldimage | oi_size | int | NULL | NULL | | oldimage | oi_timestamp | varchar | latin1 | latin1_bin | | oldimage | oi_width | int | NULL | NULL | | page | page_content_model | varbinary | NULL | NULL | | page | page_id | int | NULL | NULL | | page | page_is_new | tinyint | NULL | NULL | | page | page_is_redirect | tinyint | NULL | NULL | | page | page_lang | varbinary | NULL | NULL | | page | page_latest | int | NULL | NULL | | page | page_len | int | NULL | NULL | | page | page_links_updated | varbinary | NULL | NULL | | page | page_namespace | int | NULL | NULL | | page | page_random | double | NULL | NULL | | page | page_restrictions | tinyblob | NULL | NULL | | page | page_title | varchar | latin1 | latin1_swedish_ci | | page | page_touched | varchar | latin1 | latin1_swedish_ci | | page_props | pp_page | int | NULL | NULL | | page_props | pp_propname | varbinary | NULL | NULL | | page_props | pp_sortkey | float | NULL | NULL | | page_props | pp_value | blob | NULL | NULL | | page_restrictions | pr_cascade | tinyint | NULL | NULL | | page_restrictions | pr_expiry | char | latin1 | latin1_bin | | page_restrictions | pr_id | int | NULL | NULL | | page_restrictions | pr_level | varchar | latin1 | latin1_swedish_ci | | page_restrictions | pr_page | int | NULL | NULL | | page_restrictions | pr_type | varchar | latin1 | latin1_swedish_ci | | page_restrictions | pr_user | int | NULL | NULL | | pagelinks | pl_from | int | NULL | NULL | | pagelinks | pl_from_namespace | int | NULL | NULL | | pagelinks | pl_namespace | int | NULL | NULL | | pagelinks | pl_title | varchar | latin1 | latin1_swedish_ci | | pp_smw_redirects | displayed_in | varbinary | NULL | NULL | | pp_smw_redirects | object_declaration | mediumblob | NULL | NULL | | pp_smw_redirects | rid | int | NULL | NULL | | protected_titles | pt_create_perm | varbinary | NULL | NULL | | protected_titles | pt_expiry | varbinary | NULL | NULL | | protected_titles | pt_namespace | int | NULL | NULL | | protected_titles | pt_reason_id | bigint | NULL | NULL | | protected_titles | pt_timestamp | binary | NULL | NULL | | protected_titles | pt_title | varchar | latin1 | latin1_bin | | protected_titles | pt_user | int | NULL | NULL | | querycache | qc_namespace | int | NULL | NULL | | querycache | qc_title | char | latin1 | latin1_bin | | querycache | qc_type | char | latin1 | latin1_swedish_ci | | querycache | qc_value | int | NULL | NULL | | querycache_info | qci_timestamp | varchar | latin1 | latin1_swedish_ci | | querycache_info | qci_type | varchar | latin1 | latin1_swedish_ci | | querycachetwo | qcc_namespace | int | NULL | NULL | | querycachetwo | qcc_namespacetwo | int | NULL | NULL | | querycachetwo | qcc_title | char | latin1 | latin1_bin | | querycachetwo | qcc_titletwo | char | latin1 | latin1_bin | | querycachetwo | qcc_type | char | latin1 | latin1_swedish_ci | | querycachetwo | qcc_value | int | NULL | NULL | | recentchanges | rc_actor | bigint | NULL | NULL | | recentchanges | rc_bot | tinyint | NULL | NULL | | recentchanges | rc_comment_id | bigint | NULL | NULL | | recentchanges | rc_cur_id | int | NULL | NULL | | recentchanges | rc_deleted | tinyint | NULL | NULL | | recentchanges | rc_id | int | NULL | NULL | | recentchanges | rc_ip | varbinary | NULL | NULL | | recentchanges | rc_last_oldid | int | NULL | NULL | | recentchanges | rc_log_action | varchar | latin1 | latin1_bin | | recentchanges | rc_log_type | varchar | latin1 | latin1_bin | | recentchanges | rc_logid | int | NULL | NULL | | recentchanges | rc_minor | tinyint | NULL | NULL | | recentchanges | rc_namespace | int | NULL | NULL | | recentchanges | rc_new | tinyint | NULL | NULL | | recentchanges | rc_new_len | int | NULL | NULL | | recentchanges | rc_old_len | int | NULL | NULL | | recentchanges | rc_params | blob | NULL | NULL | | recentchanges | rc_patrolled | tinyint | NULL | NULL | | recentchanges | rc_source | varbinary | NULL | NULL | | recentchanges | rc_this_oldid | int | NULL | NULL | | recentchanges | rc_timestamp | varchar | latin1 | latin1_bin | | recentchanges | rc_title | varchar | latin1 | latin1_bin | | recentchanges | rc_type | tinyint | NULL | NULL | | redirect | rd_fragment | varchar | latin1 | latin1_bin | | redirect | rd_from | int | NULL | NULL | | redirect | rd_interwiki | varchar | latin1 | latin1_swedish_ci | | redirect | rd_namespace | int | NULL | NULL | | redirect | rd_title | varchar | latin1 | latin1_bin | | revision | rev_actor | bigint | NULL | NULL | | revision | rev_comment_id | bigint | NULL | NULL | | revision | rev_deleted | tinyint | NULL | NULL | | revision | rev_id | int | NULL | NULL | | revision | rev_len | int | NULL | NULL | | revision | rev_minor_edit | tinyint | NULL | NULL | | revision | rev_page | int | NULL | NULL | | revision | rev_parent_id | int | NULL | NULL | | revision | rev_sha1 | varbinary | NULL | NULL | | revision | rev_timestamp | varchar | latin1 | latin1_swedish_ci | | revision_actor_temp | revactor_actor | bigint | NULL | NULL | | revision_actor_temp | revactor_page | int | NULL | NULL | | revision_actor_temp | revactor_rev | int | NULL | NULL | | revision_actor_temp | revactor_timestamp | binary | NULL | NULL | | revision_comment_temp | revcomment_comment_id | bigint | NULL | NULL | | revision_comment_temp | revcomment_rev | int | NULL | NULL | | rottenlinks | rl_externallink | blob | NULL | NULL | | rottenlinks | rl_id | int | NULL | NULL | | rottenlinks | rl_pageusage | longtext | utf8 | utf8_general_ci | | rottenlinks | rl_respcode | int | NULL | NULL | | searchindex | si_page | int | NULL | NULL | | searchindex | si_text | mediumtext | latin1 | latin1_swedish_ci | | searchindex | si_title | varchar | latin1 | latin1_swedish_ci | | site_identifiers | si_key | varbinary | NULL | NULL | | site_identifiers | si_site | int | NULL | NULL | | site_identifiers | si_type | varbinary | NULL | NULL | | site_stats | ss_active_users | bigint | NULL | NULL | | site_stats | ss_good_articles | bigint | NULL | NULL | | site_stats | ss_images | bigint | NULL | NULL | | site_stats | ss_row_id | int | NULL | NULL | | site_stats | ss_total_edits | bigint | NULL | NULL | | site_stats | ss_total_pages | bigint | NULL | NULL | | site_stats | ss_users | bigint | NULL | NULL | | sites | site_config | blob | NULL | NULL | | sites | site_data | blob | NULL | NULL | | sites | site_domain | varchar | utf8 | utf8_general_ci | | sites | site_forward | tinyint | NULL | NULL | | sites | site_global_key | varbinary | NULL | NULL | | sites | site_group | varbinary | NULL | NULL | | sites | site_id | int | NULL | NULL | | sites | site_language | varbinary | NULL | NULL | | sites | site_protocol | varbinary | NULL | NULL | | sites | site_source | varbinary | NULL | NULL | | sites | site_type | varbinary | NULL | NULL | | slot_roles | role_id | smallint | NULL | NULL | | slot_roles | role_name | varbinary | NULL | NULL | | slots | slot_content_id | bigint | NULL | NULL | | slots | slot_origin | bigint | NULL | NULL | | slots | slot_revision_id | bigint | NULL | NULL | | slots | slot_role_id | smallint | NULL | NULL | | sm_coords | alt | double | NULL | NULL | | sm_coords | lat | double | NULL | NULL | | sm_coords | lon | double | NULL | NULL | | sm_coords | p_id | int | NULL | NULL | | sm_coords | s_id | int | NULL | NULL | | smw_concept_cache | o_id | int | NULL | NULL | | smw_concept_cache | s_id | int | NULL | NULL | | smw_di_blob | o_blob | mediumblob | NULL | NULL | | smw_di_blob | o_hash | varbinary | NULL | NULL | | smw_di_blob | p_id | int | NULL | NULL | | smw_di_blob | s_id | int | NULL | NULL | | smw_di_bool | o_value | tinyint | NULL | NULL | | smw_di_bool | p_id | int | NULL | NULL | | smw_di_bool | s_id | int | NULL | NULL | | smw_di_coords | o_lat | double | NULL | NULL | | smw_di_coords | o_lon | double | NULL | NULL | | smw_di_coords | o_serialized | varbinary | NULL | NULL | | smw_di_coords | p_id | int | NULL | NULL | | smw_di_coords | s_id | int | NULL | NULL | | smw_di_number | o_serialized | varbinary | NULL | NULL | | smw_di_number | o_sortkey | double | NULL | NULL | | smw_di_number | p_id | int | NULL | NULL | | smw_di_number | s_id | int | NULL | NULL | | smw_di_time | o_serialized | varbinary | NULL | NULL | | smw_di_time | o_sortkey | double | NULL | NULL | | smw_di_time | p_id | int | NULL | NULL | | smw_di_time | s_id | int | NULL | NULL | | smw_di_uri | o_blob | mediumblob | NULL | NULL | | smw_di_uri | o_serialized | varbinary | NULL | NULL | | smw_di_uri | p_id | int | NULL | NULL | | smw_di_uri | s_id | int | NULL | NULL | | smw_di_wikipage | o_id | int | NULL | NULL | | smw_di_wikipage | p_id | int | NULL | NULL | | smw_di_wikipage | s_id | int | NULL | NULL | | smw_fpt_ask | o_id | int | NULL | NULL | | smw_fpt_ask | s_id | int | NULL | NULL | | smw_fpt_askde | o_serialized | varbinary | NULL | NULL | | smw_fpt_askde | o_sortkey | double | NULL | NULL | | smw_fpt_askde | s_id | int | NULL | NULL | | smw_fpt_askdu | o_serialized | varbinary | NULL | NULL | | smw_fpt_askdu | o_sortkey | double | NULL | NULL | | smw_fpt_askdu | s_id | int | NULL | NULL | | smw_fpt_askfo | o_blob | mediumblob | NULL | NULL | | smw_fpt_askfo | o_hash | varbinary | NULL | NULL | | smw_fpt_askfo | s_id | int | NULL | NULL | | smw_fpt_askpa | o_blob | mediumblob | NULL | NULL | | smw_fpt_askpa | o_hash | varbinary | NULL | NULL | | smw_fpt_askpa | s_id | int | NULL | NULL | | smw_fpt_asksi | o_serialized | varbinary | NULL | NULL | | smw_fpt_asksi | o_sortkey | double | NULL | NULL | | smw_fpt_asksi | s_id | int | NULL | NULL | | smw_fpt_askst | o_blob | mediumblob | NULL | NULL | | smw_fpt_askst | o_hash | varbinary | NULL | NULL | | smw_fpt_askst | s_id | int | NULL | NULL | | smw_fpt_conc | cache_count | int | NULL | NULL | | smw_fpt_conc | cache_date | int | NULL | NULL | | smw_fpt_conc | concept_depth | int | NULL | NULL | | smw_fpt_conc | concept_docu | mediumblob | NULL | NULL | | smw_fpt_conc | concept_features | int | NULL | NULL | | smw_fpt_conc | concept_size | int | NULL | NULL | | smw_fpt_conc | concept_txt | mediumblob | NULL | NULL | | smw_fpt_conc | s_id | int | NULL | NULL | | smw_fpt_conv | o_blob | mediumblob | NULL | NULL | | smw_fpt_conv | o_hash | varbinary | NULL | NULL | | smw_fpt_conv | s_id | int | NULL | NULL | | smw_fpt_dtitle | o_blob | mediumblob | NULL | NULL | | smw_fpt_dtitle | o_hash | varbinary | NULL | NULL | | smw_fpt_dtitle | s_id | int | NULL | NULL | | smw_fpt_impo | o_blob | mediumblob | NULL | NULL | | smw_fpt_impo | o_hash | varbinary | NULL | NULL | | smw_fpt_impo | s_id | int | NULL | NULL | | smw_fpt_inst | o_id | int | NULL | NULL | | smw_fpt_inst | s_id | int | NULL | NULL | | smw_fpt_lcode | o_blob | mediumblob | NULL | NULL | | smw_fpt_lcode | o_hash | varbinary | NULL | NULL | | smw_fpt_lcode | s_id | int | NULL | NULL | | smw_fpt_list | o_blob | mediumblob | NULL | NULL | | smw_fpt_list | o_hash | varbinary | NULL | NULL | | smw_fpt_list | s_id | int | NULL | NULL | | smw_fpt_mdat | o_serialized | varbinary | NULL | NULL | | smw_fpt_mdat | o_sortkey | double | NULL | NULL | | smw_fpt_mdat | s_id | int | NULL | NULL | | smw_fpt_pplb | o_id | int | NULL | NULL | | smw_fpt_pplb | s_id | int | NULL | NULL | | smw_fpt_prec | o_serialized | varbinary | NULL | NULL | | smw_fpt_prec | o_sortkey | double | NULL | NULL | | smw_fpt_prec | s_id | int | NULL | NULL | | smw_fpt_pval | o_blob | mediumblob | NULL | NULL | | smw_fpt_pval | o_hash | varbinary | NULL | NULL | | smw_fpt_pval | s_id | int | NULL | NULL | | smw_fpt_redi | o_id | int | NULL | NULL | | smw_fpt_redi | s_namespace | int | NULL | NULL | | smw_fpt_redi | s_title | varbinary | NULL | NULL | | smw_fpt_serv | o_blob | mediumblob | NULL | NULL | | smw_fpt_serv | o_hash | varbinary | NULL | NULL | | smw_fpt_serv | s_id | int | NULL | NULL | | smw_fpt_sobj | o_id | int | NULL | NULL | | smw_fpt_sobj | s_id | int | NULL | NULL | | smw_fpt_subc | o_id | int | NULL | NULL | | smw_fpt_subc | s_id | int | NULL | NULL | | smw_fpt_subp | o_id | int | NULL | NULL | | smw_fpt_subp | s_id | int | NULL | NULL | | smw_fpt_text | o_blob | mediumblob | NULL | NULL | | smw_fpt_text | o_hash | varbinary | NULL | NULL | | smw_fpt_text | s_id | int | NULL | NULL | | smw_fpt_type | o_blob | mediumblob | NULL | NULL | | smw_fpt_type | o_serialized | varbinary | NULL | NULL | | smw_fpt_type | s_id | int | NULL | NULL | | smw_fpt_unit | o_blob | mediumblob | NULL | NULL | | smw_fpt_unit | o_hash | varbinary | NULL | NULL | | smw_fpt_unit | s_id | int | NULL | NULL | | smw_fpt_uri | o_blob | mediumblob | NULL | NULL | | smw_fpt_uri | o_serialized | varbinary | NULL | NULL | | smw_fpt_uri | s_id | int | NULL | NULL | | smw_object_aux | smw_countmap | mediumblob | NULL | NULL | | smw_object_aux | smw_id | int | NULL | NULL | | smw_object_aux | smw_seqmap | mediumblob | NULL | NULL | | smw_object_ids | smw_hash | varbinary | NULL | NULL | | smw_object_ids | smw_id | int | NULL | NULL | | smw_object_ids | smw_iw | varbinary | NULL | NULL | | smw_object_ids | smw_namespace | int | NULL | NULL | | smw_object_ids | smw_proptable_hash | mediumblob | NULL | NULL | | smw_object_ids | smw_rev | int | NULL | NULL | | smw_object_ids | smw_sort | varbinary | NULL | NULL | | smw_object_ids | smw_sortkey | varbinary | NULL | NULL | | smw_object_ids | smw_subobject | varbinary | NULL | NULL | | smw_object_ids | smw_title | varbinary | NULL | NULL | | smw_object_ids | smw_touched | binary | NULL | NULL | | smw_prop_stats | null_count | int | NULL | NULL | | smw_prop_stats | p_id | int | NULL | NULL | | smw_prop_stats | usage_count | int | NULL | NULL | | smw_query_links | o_id | int | NULL | NULL | | smw_query_links | s_id | int | NULL | NULL | | spoofuser | su_error | text | utf8 | utf8_general_ci | | spoofuser | su_legal | tinyint | NULL | NULL | | spoofuser | su_name | varchar | utf8 | utf8_general_ci | | spoofuser | su_normalized | varchar | utf8 | utf8_general_ci | | templatelinks | tl_from | int | NULL | NULL | | templatelinks | tl_from_namespace | int | NULL | NULL | | templatelinks | tl_namespace | int | NULL | NULL | | templatelinks | tl_title | varchar | latin1 | latin1_bin | | text | old_flags | tinyblob | NULL | NULL | | text | old_id | int | NULL | NULL | | text | old_text | mediumtext | latin1 | latin1_swedish_ci | | titlekey | tk_key | varchar | utf8 | utf8_bin | | titlekey | tk_namespace | int | NULL | NULL | | titlekey | tk_page | int | NULL | NULL | | trackbacks | tb_ex | text | latin1 | latin1_swedish_ci | | trackbacks | tb_id | int | NULL | NULL | | trackbacks | tb_name | varchar | latin1 | latin1_swedish_ci | | trackbacks | tb_page | int | NULL | NULL | | trackbacks | tb_title | varchar | latin1 | latin1_swedish_ci | | trackbacks | tb_url | varchar | latin1 | latin1_swedish_ci | | updatelog | ul_key | varchar | latin1 | latin1_swedish_ci | | updatelog | ul_value | blob | NULL | NULL | | uploadstash | us_chunk_inx | int | NULL | NULL | | uploadstash | us_id | int | NULL | NULL | | uploadstash | us_image_bits | smallint | NULL | NULL | | uploadstash | us_image_height | int | NULL | NULL | | uploadstash | us_image_width | int | NULL | NULL | | uploadstash | us_key | varchar | utf8 | utf8_general_ci | | uploadstash | us_media_type | enum | utf8 | utf8_general_ci | | uploadstash | us_mime | varchar | utf8 | utf8_general_ci | | uploadstash | us_orig_path | varchar | utf8 | utf8_general_ci | | uploadstash | us_path | varchar | utf8 | utf8_general_ci | | uploadstash | us_props | blob | NULL | NULL | | uploadstash | us_sha1 | varchar | utf8 | utf8_general_ci | | uploadstash | us_size | int | NULL | NULL | | uploadstash | us_source_type | varchar | utf8 | utf8_general_ci | | uploadstash | us_status | varchar | utf8 | utf8_general_ci | | uploadstash | us_timestamp | varbinary | NULL | NULL | | uploadstash | us_user | int | NULL | NULL | | user | user_editcount | int | NULL | NULL | | user | user_email | tinytext | latin1 | latin1_swedish_ci | | user | user_email_authenticated | varchar | latin1 | latin1_bin | | user | user_email_token | varchar | latin1 | latin1_bin | | user | user_email_token_expires | varchar | latin1 | latin1_bin | | user | user_id | int | NULL | NULL | | user | user_name | varchar | latin1 | latin1_bin | | user | user_newpass_time | char | latin1 | latin1_bin | | user | user_newpassword | tinyblob | NULL | NULL | | user | user_password | tinyblob | NULL | NULL | | user | user_password_expires | varbinary | NULL | NULL | | user | user_real_name | varchar | latin1 | latin1_bin | | user | user_registration | varchar | latin1 | latin1_bin | | user | user_token | varchar | latin1 | latin1_bin | | user | user_touched | varchar | latin1 | latin1_bin | | user_former_groups | ufg_group | varbinary | NULL | NULL | | user_former_groups | ufg_user | int | NULL | NULL | | user_groups | ug_expiry | varbinary | NULL | NULL | | user_groups | ug_group | varbinary | NULL | NULL | | user_groups | ug_user | int | NULL | NULL | | user_newtalk | user_id | int | NULL | NULL | | user_newtalk | user_ip | varchar | latin1 | latin1_swedish_ci | | user_newtalk | user_last_timestamp | varbinary | NULL | NULL | | user_properties | up_property | varbinary | NULL | NULL | | user_properties | up_user | int | NULL | NULL | | user_properties | up_value | blob | NULL | NULL | | watchlist | wl_id | int | NULL | NULL | | watchlist | wl_namespace | int | NULL | NULL | | watchlist | wl_notificationtimestamp | varchar | latin1 | latin1_bin | | watchlist | wl_title | varchar | latin1 | latin1_bin | | watchlist | wl_user | int | NULL | NULL | | watchlist_expiry | we_expiry | binary | NULL | NULL | | watchlist_expiry | we_item | int | NULL | NULL | +-----------------------+--------------------------------+------------+--------------------+-------------------+ 647 rows in set (0,08 sec) mysql> select * from category where cat_id=151642; +--------+-----------+-----------+-------------+-----------+ | cat_id | cat_title | cat_pages | cat_subcats | cat_files | +--------+-----------+-----------+-------------+-----------+ | 151642 | Städte | 2505 | 0 | 0 | +--------+-----------+-----------+-------------+-----------+ 1 row in set (0,00 sec) mysql> select * from category where cat_title='Städte'; Empty set (0,00 sec) mysql> select * from category where cat_title like 'St%dte'; +--------+-----------+-----------+-------------+-----------+ | cat_id | cat_title | cat_pages | cat_subcats | cat_files | +--------+-----------+-----------+-------------+-----------+ | 151642 | Städte | 2505 | 0 | 0 | +--------+-----------+-----------+-------------+-----------+ 1 row in set (0,00 sec)