Character Limit

>Access clearly uses non-standard data types.


lol .. no argument here. :)

Nancy

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/

> 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

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/