STRING
type
Applies to: Databricks SQL Databricks Runtime
The type supports character sequences of any length greater or equal to 0.
Syntax
STRING
Literals
[r|R]'c [ ... ]'
r
orR
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above
Optional prefix denoting a raw-literal.
c
Any character from the Unicode character set.
The following escape sequences are recognized in regular string literals (without the r
prefix) and replaced according to the following rules:
\0
->\u0000
, unicode character with the code 0;\b
->\u0008
, backspace;\n
->\u000a
, linefeed;\r
->\u000d
, carriage return;\t
->\u0009
, horizontal tab;\Z
->\u001A
, substitute;\%
->\%
;\_
->\_
;\<other char>
-><other char>
, skip the slash and leave the character as is.
If the string is prefixed with r
there is no escape character.
You can use double quotes ("
) instead of single quotes ('
) to delimit a string literal.
Examples
> SELECT 'Spark';
Spark
> SELECT CAST(5 AS STRING);
5
> SELECT 'O\'Connell'
O'Connell
> SELECT 'Some\nText'
Some
Text
> SELECT r'Some\nText'
Some\nText
> SELECT '서울시'
서울시
> SELECT ''
> SELECT '\\'
\
> SELECT r'\\'
\\
Related
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for