For exampe I have a data field length set up is varchar(100), and I insert data with 105 characters from the web form, the php and interbase works this way.
1) i got warning message.
2) the insert execution hung on there, the page was responsing very slowly. It seems the system crashed on this page. All the other pages are still fine.
3) but later the record still shows in the database. Even one field is bigger than the field length. (I didn't check if the field data is trimmed to the max length, and I don't want to repeat the error which seems create dead thread.)
Could any one explain to me why the record still get insert even one field input is too large?
Also I want to know, how you handle the field length?
1) if it is a text field, we can use html form max characters feature? but how about textarea (there is no max characters feature for textarea.
2) if we use the max character feature of HTML form on the text field, the data will just be trimmed. the user may not realize that his data is too large and it is trimmed.
3) are there any javascripts could do a better job?
4) or your prefer any better php scripts ? (I think php scripts to check on the length will have advantage to prevent when user turn off the javascript on its browser and try to input too large data into database, which will crashed the operations.)
5) what I can set up in the database to prevent it crashs when over length data input?
Thanks!
