Restrictions on text, image, and unitext columns  Converting text and image datatypes

Chapter 1: System and User-Defined Datatypes

Selecting text, unitext, and image data

The following global variables return information on text, unitext, and image data:

Table 1-19: text , unitext, and image global variables

Variable

Explanation

@@textptr

The text pointer of the last text, unitext, or image column inserted or updated by a process. Do not confuse this global variable with the textptr function.

@@textcolid

ID of the column referenced by @@textptr.

@@textdbid

ID of a database containing the object with the column referenced by @@textptr.

@@textobjid

ID of the object containing the column referenced by @@textptr.

@@textsize

Current value of the set textsize option, which specifies the maximum length, in bytes, of text, unitext, or image data to be returned with a select statement. It defaults to 32K. The maximum size for @@textsize is 231 - 1 (that is, 2,147,483,647).

@@textts

Text timestamp of the column referenced by @@textptr.





Copyright © 2005. Sybase Inc. All rights reserved. Converting text and image datatypes

View this book as PDF