data type issue with mysql
Posted: Sun Dec 17, 2006 9:59 pm
I have a form on my web site that allows new contacts to fill in their information. The information is then stored in a mysql database. One of the fields is a textarea field so the user can type as much as they want.
In mysql I have associated that textarea field with the datatype of "text".
After a lot of trial and error I am not sure if length of text is the issue but more of what kind of text is going into it. Are there limitations to what kind of text you can put in this field. I do notice that if I try to put in for instance as a test:
<a href='#'> Test link </a>
The result is that a new record is not created for that submission. To get it to work I have URLENCODED before the data is submitted into the database and that does allow it to work, but I am just wondering if there is a list of characters or an article that might shed some light on restrictions because URLENCODE did not solve all my issues regarding what I inputted into the form.
Tony
In mysql I have associated that textarea field with the datatype of "text".
After a lot of trial and error I am not sure if length of text is the issue but more of what kind of text is going into it. Are there limitations to what kind of text you can put in this field. I do notice that if I try to put in for instance as a test:
<a href='#'> Test link </a>
The result is that a new record is not created for that submission. To get it to work I have URLENCODED before the data is submitted into the database and that does allow it to work, but I am just wondering if there is a list of characters or an article that might shed some light on restrictions because URLENCODE did not solve all my issues regarding what I inputted into the form.
Tony