Previous Topic

Next Topic

Limitations of SQL_LONGVARCHAR:

  1. The LIKE predicate operates on the first 65500 characters of the column data.
  2. All other predicates operate on the first 256 characters of the column data.
  3. SELECT statements with GROUP BY, DISTINCT and ORDER BY return all of the data but only order on the first 256 characters of the column data.