Re: 255 character limit

Article View: comp.databases.ms-access

Article #358

Back to comp.databases.ms-access Previous Next

#358

From: larry.linson
Date: Mon, 29 Mar 1999 00:00

10 lines
1469 bytes

  "Dr�" <DriesAendekerk@NOSPAMbigfoot.com> wrote:
 > But that's the problem, Acces has i character limit of 255.

You are mistaken. Only _Text_ fields have a 255-character limit. You can store
text in a _Memo_ field and store up to 64K characters. You can store it in an
_OLE_ field, using the OLE field as a Binary Large Object (BLOB) and have an
essentially unlimited size.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Technical Details

Message-ID: <7dmrun$77q$1@nnrp1.dejanews.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7dl5jj$j9k$1@trex.antw.online.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 111a5a,ce5ca7dacfe5a2dd
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,ce5ca7dacfe5a2dd
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,ce5ca7dacfe5a2dd
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 10779a,ce5ca7dacfe5a2dd
X-Google-Attributes: gid10779a,public
From: larry.linson@ntpcug.org
Subject: Re: 255 character limit
Date: 1999/03/29
Message-ID: <7dmrun$77q$1@nnrp1.dejanews.com>
X-Deja-AN: 460182799
References: <7dl5jj$j9k$1@trex.antw.online.be>
X-Http-Proxy: 1.1 x6.dejanews.com:80 (Squid/1.1.22) for client 4.11.169.101
Organization: Deja News - The Leader in Internet Discussion
X-Article-Creation-Date: Mon Mar 29 03:27:27 1999 GMT
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)

Reply to Parent Message