Function Support

Learn about the Sybase IQ 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 large object data types and 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
  The BYTE_LENGTH function returns the number of bytes in a string.
• BYTE_LENGTH64 Function
  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
  The BYTE_SUBSTR64 and BYTE_SUBSTR functions return the byte substring of the large object column or variable parameter.
• CHAR_LENGTH Function
  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
  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
  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
  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
  The OCTET_LENGTH function returns an unsigned 64-bit value containing the byte length of the large object column or variable parameter.
• PATINDEX Function
  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
  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
  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.