1 Replies - 6164 Views - Last Post: 05 August 2012 - 11:26 PM

#1 arrezes  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 58
  • Joined: 17-October 10

Input from textbox truncated

Posted 29 July 2012 - 06:26 PM

I've been figuring why this is happening. A field in my form is to register a description of a task. The maximum length of the field would be less then hundred. Therefore, the table column which will hold this is of type nvarchar(100). But when I checked the table after the input, the description was truncated.

why is this happening? is it got to do with the column type or perhaps anything else?
Is This A Good Question/Topic? 0
  • +

Replies To: Input from textbox truncated

#2 arrezes  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 58
  • Joined: 17-October 10

Re: Input from textbox truncated

Posted 05 August 2012 - 11:26 PM

Hi,

I found the answer myself. I change the column datatype to varchar(MAX) but I forgot to change the stored procedure statement to reflex the changes that I made to the table accordingly.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1