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.

255 byte column size limit

2 posts in Windows NT Last posting was on 2000-03-03 18:44:09.0Z
William DeCoste Posted on 2000-03-03 18:35:27.0Z
Message-ID: <38C005EF.3F32CF53@cyclonecommerce.com>
Date: Fri, 03 Mar 2000 11:35:27 -0700
From: William DeCoste <bdecoste@cyclonecommerce.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: 255 byte column size limit
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 5
NNTP-Posting-Host: 12.34.72.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2455
Article PK: 1089910

I downloaded the demo version of ASE 11.5 and it seems the column sizes
are limited to 255 bytes ( tinyint? ). Is there a way to increase the
size? I need a 1500 byte binary column.


Jason Froebe Posted on 2000-03-03 18:44:09.0Z
Message-ID: <38C007F9.8559432D@sybase.com>
Date: Fri, 03 Mar 2000 12:44:09 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: William DeCoste <bdecoste@cyclonecommerce.com>
Subject: Re: 255 byte column size limit
References: <38C005EF.3F32CF53@cyclonecommerce.com>
Content-Type: multipart/mixed; boundary="------------3FA86BF6CE7291B0B6505BB4"
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2454
Article PK: 1089904


William DeCoste wrote:

> I downloaded the demo version of ASE 11.5 and it seems the column sizes
> are limited to 255 bytes ( tinyint? ). Is there a way to increase the
> size? I need a 1500 byte binary column.

Hi William,

The size of a tinyint will vary from platform to platform. As for the
binary column, take a look at the image datatype.

Jason


Download VCard jfroebe.vcf