Share via

String limitations

  • Article

The maximum length of an SQL statement string is 65,000 characters.

When the Microsoft Access driver is used, only SQL-92 string constants (with single quotation marks, not double quotation marks) are supported.

The pipe character (|) can't be used in a string, whether the character is enclosed in back quotes or not.

For maximum interoperability, applications should pass strings in parameters, rather than passing quoted strings.