moojjoo (5/12/2009)
When submitted to SQL the extra characters are simply dropped [(1)What is the offical name for this?];
"Truncation"
moojjoo (5/12/2009)
What is the best practice.
Generally, its better to validate the input at the front end itself rather than accepting invalid data and avoiding the problems that may arise due to invalid data.
--Ramesh