Db saves only first letter of the record

Question

i have as serious question.is there any scenario that when we inserting records only first letter of the record inserts.because i m facing it now.while debugging its fine but when i open my DB it shows only first letters like ..if i insert answers  in DB it saves like a only ...why this can anyone expalin me how to resolve this Thanks and Regards

Bikesh Srivastava · Answer

check you size limit of field .

aditya immadi · Answer

thanks for the reply guys .i found out .i forgot to mention size in my procedure that is instead of nvachar(max ) i follow just nvarchar

Salman · Answer

Hi aditya. Please check the size of that field in database. Because if the field size is very less in db then it can store upto that size only. Thanks.

Nitin Sontakke · Answer

Please accept one of the suggested answer. It's good practice.

Salman · Answer

Thanks buddy. great keep it up.