Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

how many characters are allowed in text datatype in ASE 12.5

7 posts in General Discussion Last posting was on 2009-12-19 21:15:13.0Z
Vinay Posted on 2009-12-17 20:28:17.0Z
Sender: 5aec.4b2a8d52.1804289383@sybase.com
From: Vinay
Newsgroups: sybase.public.ase.general
Subject: how many characters are allowed in text datatype in ASE 12.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b2a9461.5bc2.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2009 12:28:17 -0800
X-Trace: forums-1-dub 1261081697 10.22.241.41 (17 Dec 2009 12:28:17 -0800)
X-Original-Trace: 17 Dec 2009 12:28:17 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28788
Article PK: 78031

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


J Posted on 2009-12-17 22:27:55.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
Reply-To: J@bogusemailAddress.com
Message-ID: <4b2aaef4.70006684@forums.sybase.com>
References: <4b2a9461.5bc2.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 17 Dec 2009 14:27:55 -0800
X-Trace: forums-1-dub 1261088875 10.22.241.152 (17 Dec 2009 14:27:55 -0800)
X-Original-Trace: 17 Dec 2009 14:27:55 -0800, vip152.sybase.com
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28790
Article PK: 78029

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


Vinay Posted on 2009-12-17 23:26:56.0Z
Sender: 5c56.4b2a9d45.1804289383@sybase.com
From: Vinay
Newsgroups: sybase.public.ase.general
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b2abe40.6105.1681692777@sybase.com>
References: <4b2aaef4.70006684@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2009 15:26:56 -0800
X-Trace: forums-1-dub 1261092416 10.22.241.41 (17 Dec 2009 15:26:56 -0800)
X-Original-Trace: 17 Dec 2009 15:26:56 -0800, 10.22.241.41
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28791
Article PK: 78032

Thanks for your response. This seems to increase the
textsize, but still the UPDATE seems to truncate anything
more than 32768. I have coded the update after increazing
the text size.

set textsize 1000000
go
select @@textsize
go

Update table
set textcolumn = ''''''''''
--
Is there anything else that needs to be checked ?

Regards

> 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
>


J Posted on 2009-12-18 21:23:04.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
Reply-To: J@bogusemailAddress.com
Message-ID: <4b2bf289.152839231@forums.sybase.com>
References: <4b2aaef4.70006684@forums.sybase.com> <4b2abe40.6105.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Dec 2009 13:23:04 -0800
X-Trace: forums-1-dub 1261171384 10.22.241.152 (18 Dec 2009 13:23:04 -0800)
X-Original-Trace: 18 Dec 2009 13:23:04 -0800, vip152.sybase.com
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28797
Article PK: 78037

On 17 Dec 2009 15:26:56 -0800, Vinay wrote:

I don't understand exactly how you are doing the update. Could you
code the complete example? Are you using isql or some client program
etc?

Jay

>Thanks for your response. This seems to increase the
>textsize, but still the UPDATE seems to truncate anything
>more than 32768. I have coded the update after increazing
>the text size.
>
>set textsize 1000000
>go
>select @@textsize
>go
>
>Update table
>set textcolumn = ''''''''''
>--
>Is there anything else that needs to be checked ?
>
>Regards
>
>
>
>
>> 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
>>


Vinay Posted on 2009-12-19 21:15:13.0Z
Sender: 65c7.4b2af440.1804289383@sybase.com
From: Vinay
Newsgroups: sybase.public.ase.general
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b2d4261.1a95.1681692777@sybase.com>
References: <4b2bf289.152839231@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Dec 2009 13:15:13 -0800
X-Trace: forums-1-dub 1261257313 10.22.241.41 (19 Dec 2009 13:15:13 -0800)
X-Original-Trace: 19 Dec 2009 13:15:13 -0800, 10.22.241.41
Lines: 75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28798
Article PK: 78038

Thanks for your responses. I was wrong. The updates were
actually happening, but while reading data using SELECT it
was trunctating anything more than 32768 as I was getting a
bind error after using set textsize. With a different Sql
editor, I am able to read all the Data.

Thanks,
Vinay

> On 17 Dec 2009 15:26:56 -0800, Vinay wrote:
>
> I don't understand exactly how you are doing the update.
> Could you code the complete example? Are you using isql or
> some client program etc?
>
> Jay
>
> >Thanks for your response. This seems to increase the
> >textsize, but still the UPDATE seems to truncate anything
> >more than 32768. I have coded the update after increazing
> >the text size.
> >
> >set textsize 1000000
> >go
> >select @@textsize
> >go
> >
> >Update table
> >set textcolumn = ''''''''''
> >--
> >Is there anything else that needs to be checked ?
> >
> >Regards
> >
> >
> >
> >
> >> 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
> >>
>


Luc Van der Veurst Posted on 2009-12-18 16:54:49.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <4b2aaef4.70006684@forums.sybase.com> <4b2abe40.6105.1681692777@sybase.com>
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2bb3d9$1@forums-1-dub>
Date: 18 Dec 2009 08:54:49 -0800
X-Trace: forums-1-dub 1261155289 10.22.241.152 (18 Dec 2009 08:54:49 -0800)
X-Original-Trace: 18 Dec 2009 08:54:49 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28796
Article PK: 78039


<Vinay> wrote in message news:4b2abe40.6105.1681692777@sybase.com...
> Thanks for your response. This seems to increase the
> textsize, but still the UPDATE seems to truncate anything
> more than 32768. I have coded the update after increazing
> the text size.
>
> set textsize 1000000
> go
> select @@textsize
> go
>
> Update table
> set textcolumn = ''''''''''
> --
> Is there anything else that needs to be checked ?

Setting the textsize with the set textsize command only changes the size for
the
current session. So if you do your update via another connection,
it doesn't have any effect.
Might this be the cause of what you're experiencing ?

Luc.





> Regards
>
>
>
>
>> 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
>>


John Flynn Posted on 2009-12-18 16:34:51.0Z
From: "John Flynn" <jflynn@miqs.com>
Newsgroups: sybase.public.ase.general
References: <4b2a9461.5bc2.1681692777@sybase.com> <4b2aaef4.70006684@forums.sybase.com>
Subject: Re: how many characters are allowed in text datatype in ASE 12.5
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2baf2b$1@forums-1-dub>
Date: 18 Dec 2009 08:34:51 -0800
X-Trace: forums-1-dub 1261154091 10.22.241.152 (18 Dec 2009 08:34:51 -0800)
X-Original-Trace: 18 Dec 2009 08:34:51 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28795
Article PK: 78040


J wrote:
> 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

My understanding is that the @@textsize has an effect only when reading, not
writing. IOW, when you extract a text field from the database to the client,
it will be limited to the @@textsize; but when you send a text field from
the client into the database, the @@textsize limit has no bearing. But I
could be wrong.

- John.