v.20.1New Feature

Added randomASCII function for generating random printable ASCII strings

Official CH changelog text
Added the randomASCII(length) function, generating a string with a random set of ASCII printable characters. #8401 (BayoNet)
Added the randomASCII(length) function to generate a string containing random printable ASCII characters.

Why it matters

This feature provides users with an easy way to generate random strings composed of printable ASCII characters, useful for testing, data anonymization, or generating random identifiers.

How to use it

Use the function by calling randomASCII(length) in your queries, where length is the desired number of random ASCII characters. For example:

SELECT randomASCII(10)

Related resources

PreviousNext