Click here to Skip to main content
15,885,032 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am making a profile system, I have a field named AboutMe in database, its datatype is text

this field may contain maximum 30,000 characters. The problem is arising is that if i am using up to 27,000 characters(or more than 4,000), they are not shown on UI, instead it truncated the content and show only few characters.
It shows less than 4,000 characters if i use more than 4000 or 4000 characters

Kindly suggest me its solution
Posted
Comments
ZurdoDev 7-Mar-12 8:00am    
How are you showing it in the UI?
Saral S Stalin 15-Mar-12 2:22am    
Most likely reason is some where in the code you are casting the column to nvarchar/varchar(4000). Please post your relavant UI code and the stored procedure/query used for pulling the results from the database.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900