Character string literals
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Service Cloud 7.1
- Documentation
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'