To save comments of length of 4000 characters

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Hi

I tried to save data of 4000 characters in sql db .
data type is varchar(4000) .
UI i had used asp text box .
Currently am able to save only 3946characters . In order to save 4000characters what i need to do .

Thanks in advance

Posted 9-Jul-12 2:58am

Vinodh.B

Add a Solution

Comments

Om Prakash Pant 9-Jul-12 9:05am

can you show us the code that you tried so far?

Vinodh.B 9-Jul-12 9:24am

ObjComments = commentEntryText.Text.Trim();
then build a insert query & assign it & insert the into db

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Answer 1 · 2012-07-09T05:51:00

It is definitely possible to save 4000 character comments to a varchar(4000) field. One possibility is that you have miscounted your characters. For instance, I believe line breaks count as a character, as do spaces and tabs.

To verify that this isn't a SQL issue, try doing an INSERT statement using the Query Editor. Use the REPLCIATE command to generate the requisite number of characters like so:

SQL

INSERT INTO yourTable (yourColumn) VALUES (REPLICATE('x', 4000));

If that query works (once you modify it to be accurate for your environment) then you know the issue is with the data you are sending in or with your application.

The only other issue I can think of is something to do with your SQL setup. Maybe you upgraded from SQL 2000 and you are still operating in SQL 2000 compatibility mode. If so, then the row size limit is 8060 bytes. Since varchar only takes up one byte per character (unlike nvarchar, which uses two), you would have to have a lot of data in the row besides the comments. However, it could be possible. If you are operating in SQL 2005 mode, then you won't have that issue since variable data can be up to 8MB I believe.

SalCon · Answer 2 · 2012-07-09T07:33:00

Solution 2

How about altering the target column in the database as nvarchar(max)[^]?

Posted 9-Jul-12 7:33am

SalCon

Vinodh.B · Answer 3 · 2012-07-13T02:28:00

Solution 3

CAST('' as varchar(4000)) Solved the issue .

Posted 13-Jul-12 2:28am