Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does CF limit the amount of characters (text) you can insert

Status
Not open for further replies.

BrimReap

Programmer
Mar 8, 2002
9
US
Hi,

Does CF limit the amount of characters (text) you can insert into a SQL database field with data type "text?" Microsoft says it can do up to 2GB. My data keeps getting truncated when I try and insert a big text document via a form.
 
You can try to change the long text buffer limitation in CF administrator.The step is go to your CF administrator page, select datasources, choose your project datasource to edit,click show advanced Settings, change Long Text Buffer (chr) to greater amount.
 
check you database. what are you using? access default is 50 char for a 'text' field, up to 255.
A 'memo' field will hold much much much more :)

MSSQL databases have similar settings IIRC...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top