Input info too long for database to handle

When I copy a short piece of text from MS Word, the submission is successful, but with longer pieces (one page or greater), I get the error: String or binary data would be truncated.

details: MS Word 2000; Windows XP; IE 6.0 (I know, old version, but I can't imagine that's what's causing the error); MS SQL database varchar (8000) - 8000 is the max.

What can I do?

Mon, 05/04/2009 - 23:12

alfonsoml

Joined: 31/12/2006

Posts: 3737

Re: Input info too long for database to handle

Obviously the answer is that you need to increase the database field size.

Tue, 05/05/2009 - 13:15

dcleslie7

Joined: 15/04/2009

Posts: 4

Re: Input info too long for database to handle

I'm using nvarchar in MS SQL - 8000 is the max.
Is there another option that I'm unaware of??

Sat, 05/09/2009 - 03:29

s1dev

Joined: 09/05/2009

Posts: 1

Re: Input info too long for database to handle

For [almost] unlimited sized text content, you'll want to use 'text' or 'ntext' field type.

See this link for field types in MS SQL Server:

http://msdn.microsoft.com/en-us/library/aa258271.aspx

hth!