v.24.5Improvement

Support for English-style Unicode Quotes in Queries

Official CH changelog text
Support English-style Unicode quotes, e.g. “Hello”, ‘world’. This is questionable in general but helpful when you type your query in a word processor, such as Google Docs. This closes #58634. #63381 (Alexey Milovidov).
Added support for English-style Unicode quotes (e.g., “Hello”, ‘world’) in ClickHouse queries.

Why it matters

This feature addresses the issue where users copying queries from word processors like Google Docs face syntax errors due to curly Unicode quotes. By recognizing these quotes natively, ClickHouse improves usability and reduces manual query corrections.

How to use it

Users can now write queries containing English-style Unicode quotes directly without any special configuration or escaping. The parser automatically accepts these quotes as valid delimiters.

Related resources

PreviousNext