Show TOC

Entry Format for Character DataLocate this document in the navigation structure

Literal <char>, <varchar, >and< text >values—or their equivalents—must be enclosed in single quotation marks.

You can embed single quotation marks in <char> and <varchar> literals in two ways. Use two consecutive quotation marks to represent a single embedded quotation mark, as in this example:
'''You can have cake if you bake it,'' Ed claims.'

The first and last quotation marks delimit the character string. The two internal pairs of quotation marks are interpreted as embedded single quotation marks.

Replication Server generates single quotation marks when it substitutes a character value for a variable in a function-string template.