Unanswered: problem while retrieving data from the db
i m giving 50 varchar(50) space to my user to write there name in my app
but more often the name just occupy only 12 to 15 chars of space and left the other empty
so mine problem is when i try to fetch that name from he db then the name apears on the field along with all the empty space also appears
so suppose user entered name of length 10 we should get a string of length 10 while retrieving from the db but i m getting string of length 50 in which
data is just till 10 chars and rest is empty spaces
how to solve this problem ?