What is the maximum number of characters that can be updated to a database in a text area. When I update a record with a lot of data in a text area, the database needs to be repaired.

Any ideas?

Hi

I can only talk about access but a text field is defaulted to 50 characters. This can be increased to 255.

If you are using a lot of text change the default in the database to Memo.

As for other databases not sure as I have never used them.

Cheers

Perry

....It's only easy if you know the answer

thanks, i'm more interested in how many characters can be passed from a form in dreamwweaver

He IS talking about how many characters can be passed from a form. A form is just a gateway, with unlimited character potential... the limiting factor is the location the information is going to from the form.

If it is a database, then you must set the limit in there. (As he mentioned...)

If it is an email, then it usually doesn't matter as it is unlimited by default. (At least with CDONTS...)

Hope that helps... I got your back, Perry. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

(DWMX|IIS5|Access2K|XP|ASP/VB)
*Connman21*
www.conncreativemedia.com

Connman is correct, in our KPN application I created a textarea where users can paste their word docs straight into a "TEXT" field in SQL server and boy, some are really long...and I don't mean 10.000 characters long, i mean LONG.

But it's now obsolete, with the arrival of CFMX with free verity server <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

BTW, Access memo field is limited to 1024 chars, if i remember correctly, so that makes it pretty useless. Right now i'm playing with a HTML editor that posts to a 'TEXT' field in SQL and i can create very very long webpages.

Also note that Access breaks if it reaches it's limit of 1GB diskspace, we tried this since even M$ could not answer us. Took 30 minutes on my 1GHz Athlon, then the script stopped with a "Maximum size reached" error.

About the SQL field type "TEXT", I can happily inform you that it can hold upto 2,147,483,647 characters, if you use nTEXT for Unicode then you can use half that number.

Hope that clears up some misunderstandings.

with regards,

Dennis van Galen
DMXzone Manager

Extension, Tutorial and FAQ's Manager

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

An Access memo field can have up to 65,535 characters ... here is an extract from the Access help files.

<b>Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.)</b>

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

whoops, sorry, got confused with another data type.
It's still rather small compared to TEXT in SQL and since Access is not wise to use on websites that get more then 12 visitors at the same time...

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>

Hope that helps... I got your back, Perry. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

(DWMX|IIS5|Access2K|XP|ASP/VB)
*Connman21*
www.conncreativemedia.com
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Lost me there Connman - I got your back, Perry.

Cheers and regards

Perry

....It's only easy if you know the answer

the bottom line is that access is fucking shiiiiiiiiiiiiiiiite and it's not worth the effort. you might aswell use pen and paper. it's faster and much more efficient.

------------------------
Julio

PHP | MySQL | DWMX | ColdFusion

ICQ: 19735247

Edited by - poolio on 10 Feb 2003 09:55:59

Actually, I have been able to use MS Access for a lot of small to mid-size dynamic websites without any problems. There is a ton of support out there, including the fact that most Ultradev/MX books have used it as their default development example...

I think this saying sums it up:
A good craftsman never blames his tools.

(DWMX|IIS5|Access2K|XP|ASP/VB)
*Connman21*
www.conncreativemedia.com

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Actually, I have been able to use MS Access for a lot of small to mid-size dynamic websites without any problems<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Me too

Regards,
Dave

UD4 | Flash 5 | SQL | Access | ASP/VBScript | XP-Pro

thanks lads, I think the key is that Access isn't good at coping with a lot of data in one field, it always corrupts the database when updating.

I have split the field up now.