NexusDB

<quote> [ <character representation>... ] <quote>

[ { separator <quote> [ <character representation>... ] <quote> }... ]

[ N ] <quote> [ <character representation>... ]

[ { separator <quote> [ <character representation>... ] <quote> }... ]

[ GUID ] <quote> <character representation>... <quote>

X <quote> [ { <hexit> <hexit> }... ] <quote>

[ { separator <quote> [ { <hexit> <hexit> }... ] <quote> }... ]

|

nonquote-character

<quote symbol>

Data Type

Literal Examples

CHAR

'A character string literal is a sequence of characters enclosed in single quotes.'

VARCHAR

'The quote character ( '' ) is embedded in a literal by using two quote characters.'

CLOB

'Character string literals are also used with CLOB types. '

'String literals may be split onto multiple lines like this example.'

NCHAR

N'In formal SQL:2003 syntax, national character string literals are prefixed with a N.'

NCHAR

'NexusDB SQL supports national character string literals without the N prefix.'

GUID

GUID '{E5C37F97-0F9F-47FB-8B55-30FDEC0026E1}'

BLOB

X'4E6578757344422056322069732061206772656174205244424D532E'

SQL:2003 standard

NexusDB extensions

-

-

-

-

-

-

-

Core SQL

Feature F421 "National character"

Feature T041 "Basic LOB data type support"

Feature F271 "Compound character literals"

The N prefix in a national character string literal is optional

GUID literal

Binary literal notation with hexadecimal values inside square brackets