Function Support

Learn about the functions that support the LONG BINARY and LONG VARCHAR data types.

• Summary of Function Support of Large Object Data
  A summary of function support of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types and LONG BINARY and LONG VARCHAR variables.
• BIT_LENGTH Function
  The BIT_LENGTH function returns an unsigned 64-bit value containing the bit length of the large object column or variable parameter. If the argument is NULL, BIT_LENGTH returns NULL.
• BYTE_LENGTH Function [String]
  Returns the number of bytes in a string.
• BYTE_LENGTH64 Function [String]
  The BYTE_LENGTH64 function returns an unsigned 64-bit value containing the byte length of the large object column or variable parameter.
• BYTE_SUBSTR64 and BYTE_SUBSTR Functions [String]
  The BYTE_SUBSTR64 and BYTE_SUBSTR functions return the byte substring of the large object column or variable parameter.
• CHAR_LENGTH Function [String]
  The CHAR_LENGTH function returns a signed 32-bit value containing the character length of the LONG VARCHAR column or variable parameter, including the trailing blanks.
• CHAR_LENGTH64 Function [String]
  The CHAR_LENGTH64 function returns an unsigned 64-bit value containing the character length of the LONG VARCHAR column or variable parameter, including the trailing blanks.
• CHARINDEX Function [String]
  The CHARINDEX function returns a 64-bit signed integer containing the position of the first occurrence of the specified string in the large object column or variable parameter. For CHAR and VARCHAR columns, CHARINDEX returns a 32-bit signed integer position.
• LOCATE Function [String]
  The LOCATE function returns a 64-bit signed integer containing the position of the specified string in the large object column or variable parameter. For CHAR and VARCHAR columns, LOCATE returns a 32-bit signed integer position.
• OCTET_LENGTH Function [String]
  The OCTET_LENGTH function returns an unsigned 64-bit value containing the byte length of the large object column or variable parameter.
• PATINDEX Function [String]
  The PATINDEX function returns a 64-bit unsigned integer containing the position of the first occurrence of the specified pattern in a LONG VARCHAR column or variable. For CHAR and VARCHAR columns, PATINDEX returns a 32-bit unsigned integer position.
• SUBSTRING Function [String]
  The SUBSTRING function returns a variable-length character string of the LONG VARCHAR column or variable parameter. If any of the arguments are NULL, SUBSTRING returns NULL.
• SUBSTRING64 Function [String]
  The SUBSTRING64 function returns a variable-length character string of the large object column or variable parameter.
• Aggregate Function Support of Large Object Columns
  Only the aggregate function COUNT (*) is supported for LONG BINARY and LONG VARCHAR columns.
• User-Defined Function Support of Large Object Columns
  Scalar and aggregate user-defined functions support large object data types LONG VARCHAR (CLOB) and LONG BINARY (BLOB) up to 4GB (gigabytes) as input parameters. LOB data types are not supported as output parameters.