On 17 Dec 2009 12:28:17 -0800, Vinay wrote:
You are using an UPDATE statement and what client library? ctlib,
jConnect, ODBC etc. There will normally be a default limit on text on
ctlib connections of 32K. You can change this on your
connection/session different ways.
1> select @@textsize
2> go
-----------
32768
(1 row affected)
1> set textsize 1000000
2> go
1> select @@textsize
2> go
-----------
1000000
(1 row affected)
Jay
>Can anyone tell me how many characters(including spaces) are
>allowed in a text datatype in ASE 12.5. When I try to update
>that column it truncates any characters that exceed 32,767
>limit.
>I read that text can hold upto 2^32 characters. If so, how
>do I update much more than 32767 characters using an UPDATE
>statement ?
>
>Regards,
>vinay
|