Character Limit

[Guest]

How can I allow a field in a record insertion to be longer than 255 characters? I am using an Access database -- is this an Access issue, or is it something I can alter in DW?

[Newsgroup_User · Accepted solution]

It's Access. Change from a text field to a memo field.


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"jennivazquez" <webforumsuser@macromedia.com> wrote in message
news:e7ou1k$hk9$1@forums.macromedia.com...
> How can I allow a field in a record insertion to be longer than 255
> characters? I am using an Access database -- is this an Access issue, or
> is it something I can alter in DW?

[Newsgroup_User]

jennivazquez wrote:
> How can I allow a field in a record insertion to be longer than 255 characters? I am using an Access database -- is this an Access issue, or is it something I can alter in DW?

I don't know the names of the column types in Access, but 255 characters
is the maximum for VARCHAR in other databases, such as MySQL prior to
version 5.0. Instead of VARCHAR, choose TEXT (or the Access equivalent).

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

> I don't know the names of the column types in Access, but 255 characters
> is the maximum for VARCHAR in other databases, such as MySQL prior to
> version 5.0. Instead of VARCHAR, choose TEXT (or the Access equivalent).

David:

In Access, a TEXT field will only allow 255 characters. As I told the
poster, if you want more, you have to use a MEMO field in Access.

Still TEXT in DW.


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

[Newsgroup_User]

Nancy *Adobe Community Expert* wrote:
> In Access, a TEXT field will only allow 255 characters. As I told the
> poster, if you want more, you have to use a MEMO field in Access.

Thanks for pointing out the correct terminology, Nancy. Access clearly
uses non-standard data types.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

>Access clearly uses non-standard data types.


lol .. no argument here. :)

Nancy