Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

format_csv_* format settings

These settings are autogenerated from source.

format_csv_allow_double_quotes

Type
Bool
Default
1

If it is set to true, allow strings in double quotes.

format_csv_allow_single_quotes

Type
Bool
Default
0
Version history
VersionDefault valueComment
22.70Most tools don't treat single quote in CSV specially, don't do it by default too

If it is set to true, allow strings in single quotes.

format_csv_delimiter

Type
Char
Default
,

The character to be considered as a delimiter in CSV data. If setting with a string, a string has to have a length of 1.

format_csv_null_representation

Type
String
Default
\N

Custom NULL representation in CSV format

Navigation