title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/RowBinary/RowBinaryWithNamesAndTypes.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✔ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Similar to the [RowBinary](/docs/interfaces/formats/RowBinary) format, but with added header:

- [`LEB128`](https://en.wikipedia.org/wiki/LEB128)-encoded number of columns (N).
- N `String`s specifying column names.
- N `String`s specifying column types.

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `RowBinary` type formats.

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`format_binary_max_string_size`](/docs/operations/settings/formats#format_binary_max_string_size) The maximum allowed size for String in RowBinary format. `1GiB`| [`output_format_binary_encode_types_in_binary_format`](/docs/operations/settings/formats#input_format_binary_decode_types_in_binary_format) Allows to write types in header using [`binary encoding`](/docs/sql-reference/data-types/data-types-binary-encoding) instead of strings with type names in [`RowBinaryWithNamesAndTypes`](/docs/interfaces/formats/RowBinaryWithNamesAndTypes) output format. `false`| [`input_format_binary_decode_types_in_binary_format`](/docs/operations/settings/formats#input_format_binary_decode_types_in_binary_format) Allows to read types in header using [`binary encoding`](/docs/sql-reference/data-types/data-types-binary-encoding) instead of strings with type names in [`RowBinaryWithNamesAndTypes`](/docs/interfaces/formats/RowBinaryWithNamesAndTypes) input format. `false`| [`output_format_binary_write_json_as_string`](/docs/operations/settings/formats#output_format_binary_write_json_as_string) Allows to write values of the [`JSON`](/docs/sql-reference/data-types/newjson) data type as `JSON` [String](/docs/sql-reference/data-types/string) values in [`RowBinary`](/docs/interfaces/formats/RowBinary) output format. `false`| [`input_format_binary_read_json_as_string`](/docs/operations/settings/formats#input_format_binary_read_json_as_string) Allows to read values of the [`JSON`](/docs/sql-reference/data-types/newjson) data type as `JSON` [String](/docs/sql-reference/data-types/string) values in [`RowBinary`](/docs/interfaces/formats/RowBinary) input format. `false` | | | | | | | | | | | | | | | | | |

Note

If setting [`input_format_with_names_use_header`](/docs/operations/settings/formats#input_format_with_names_use_header) is set to 1,
the columns from input data will be mapped to the columns from the table by their names, columns with unknown names will be skipped if setting [input\_format\_skip\_unknown\_fields](/docs/operations/settings/formats#input_format_skip_unknown_fields) is set to 1.
Otherwise, the first row will be skipped.
If setting [`input_format_with_types_use_header`](/docs/operations/settings/formats#input_format_with_types_use_header) is set to `1`,
the types from input data will be compared with the types of the corresponding columns from the table. Otherwise, the second row will be skipped.

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?