Hi all,

I am having user defined datatype, whose storage type is "text". I am unable to populate data not more than 32768 chars i.e (select @@textsize = 32768). Adding a new text dataype by default takes only length as 16 (i.e 16*2K = 16*2*1024 = 32768). Is there any way that i can set the lengh column to 32, so that the current column of that datatype accepts more characters.

1> sp_help T_SIGMA_FILE_TYPE
2> go
|Type_name |Storage_type|Length|Prec|Scale|Nulls|Default_name |Rule_name|Access_Rule_name|Identity |
|-----------------|------------|------|----|-----|-----|------------|---------|----------------|----------|
|T_SIGMA_FILE_TYPE|text | 16|NULL| NULL| 0|NULL |NULL |NULL | 0|

(1 row affected)
(return status = 0)


Sybase ASE - 15.0.2
Page Size - 2K

Thanks