<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 type fields you can not add a max length and the update or insert is truncated.
This problem does not occur using SQL code to perform the same tasks within a <CFQUERY> tag. This suggests that the CF SERVER is generating flawed SQL for MySQL, or there is something I need to do with the MySQL driver. Or change it.
Would the standard MySQL driver be considered as ODBC or Native.
The CF Server is the linux version.
Any suggestions?
PS this is my first try with a CF/Linux/MySQL combination so I may have messed up something basic.
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 type fields you can not add a max length and the update or insert is truncated.
This problem does not occur using SQL code to perform the same tasks within a <CFQUERY> tag. This suggests that the CF SERVER is generating flawed SQL for MySQL, or there is something I need to do with the MySQL driver. Or change it.
Would the standard MySQL driver be considered as ODBC or Native.
The CF Server is the linux version.
Any suggestions?
PS this is my first try with a CF/Linux/MySQL combination so I may have messed up something basic.