Click here to Skip to main content
13,052,696 members (63,144 online)
Rate this:
Please Sign up or sign in to vote.
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 6-Mar-12 20:35pm
ryanb31 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 7 Mar 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100