This topic is locked

Extra character

11/11/2006 4:45:58 PM
ASPRunnerPro General questions
P
pharaon_98 author

Hi is it possible to prevent a field from being filed with blanks of the amount of data entered in a text box is shorter then the amount permitted on the field database?
Ex. I enter "Unit" (4 characters long) in a field that accept 25 characters long.
When I edit that field, i cannot add letters before i erase the rest of the line.
I'm sure there is a way to prevent that.
Thanks

Alexey admin 11/13/2006

Hi,
to avoid padding you need to change your database field type from CHAR to VARCHAR.