<CFINPUT> and <CFUPDATE> tags will only insert the first 10 charaters to alphnumeric fields when a max length has not been specified in a MySQL field.
This is easy to solve if for say VARCHAR because you simply add a max length VERCHAR(150)and there is no truncation. However in BLOB and TEXT...
I am testing a MSACCESS/MySQL conversion tool.
Conversion worked well apart from the conversion of : (Access)"MEMO" field to (MySql)"TEXT" field.
The (MySql) "TEXT" field created has no length specified but only accepts 10 characters then truncates.
The tablename...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.