Thread: long text field
View Single Post
  #1 (permalink)  
Old June 6th, 2008, 04:44 AM
SKhna SKhna is offline
Authorized User
 
Join Date: Jan 2008
Location: , , .
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default long text field

 Hi

I have a textbox field that take 2000 characters from user..Then I used a store procedure to save that user input into database through an insert statement, but for some reason it just never store the whole string of 2000 characters but only store some of it (like 100 or something) .. Seems like a data type problem…(I am using SQL server 2000)



This is what I have defined:



---------------------------------------

In storeprocedure:



@iidea2 varchar(2000)





Table Design



Idea2 varchar 2000





Aspx page



cmd.Parameters.Add(New SqlParameter("@iidea2", SqlDbType.VarChar)).Value = Idea2



Reply With Quote