Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

mysql_map_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

mysql_map_fixed_string_to_text_in_show_columns

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.21Reduce the configuration effort to connect ClickHouse with BI tools.

When enabled, FixedString ClickHouse data type will be displayed as TEXT in SHOW COLUMNS.

Has an effect only when the connection is made through the MySQL wire protocol.

  • 0 - Use BLOB.
  • 1 - Use TEXT.

mysql_map_string_to_text_in_show_columns

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.21Reduce the configuration effort to connect ClickHouse with BI tools.

When enabled, String ClickHouse data type will be displayed as TEXT in SHOW COLUMNS.

Has an effect only when the connection is made through the MySQL wire protocol.

  • 0 - Use BLOB.
  • 1 - Use TEXT.
Navigation