skip to main content
Supported SQL statements and extensions : SQL expressions : Literals : Character string literals
  

Try DataDirect Drivers Now
Character string literals
Text specifies a character string literal. A character string literal must be enclosed in single quotation marks. To represent one single quotation mark within a literal, you must enter two single quotation marks. When the data in the fields is returned to the client, trailing blanks are stripped.
A character string literal can have a maximum length of 32 KB, that is, (32*1024) bytes.

Example

'Hello'
'Jim''s friend is Joe'