Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
mysql_map_fixed_string_to_text_in_show_columns

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

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.
Last modified on July 23, 2026