Limits of @@textsize

select statements return text, image, and unitext data up to the limit specified in the global variable @@textsize. The set textsize command is used to change this limit. The initial value of @@textsize is 32K; the maximum value for @@textsize is 2147MB.