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.

max size of text record

2 posts in General Discussion Last posting was on 2011-10-06 12:28:26.0Z
matal Posted on 2011-10-06 11:05:01.0Z
Sender: 3ecb.4e8d53ef.1804289383@sybase.com
From: matal
Newsgroups: sybase.public.ase.general
Subject: max size of text record
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e8d8b5d.4b88.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Oct 2011 04:05:01 -0700
X-Trace: forums-1-dub 1317899101 10.22.241.41 (6 Oct 2011 04:05:01 -0700)
X-Original-Trace: 6 Oct 2011 04:05:01 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30576
Article PK: 73467

How can I determine the size if one record's data in a text
column ?


Rob V Posted on 2011-10-06 12:28:26.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: max size of text record
References: <4e8d8b5d.4b88.1681692777@sybase.com>
In-Reply-To: <4e8d8b5d.4b88.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e8d9eea$1@forums-1-dub>
Date: 6 Oct 2011 05:28:26 -0700
X-Trace: forums-1-dub 1317904106 10.22.241.152 (6 Oct 2011 05:28:26 -0700)
X-Original-Trace: 6 Oct 2011 05:28:26 -0700, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30577
Article PK: 73469


On 06-Oct-2011 13:05, matal wrote:
> How can I determine the size if one record's data in a text
> column ?

select datalength(your-text-column)
from your_table
where primary_key_column = some-value

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------