i checked with the LENGTH function , it actually shows the length as 1000 for the one which has data more than 1000 chars