phone number comes in as '0' in MySQL Database
I used the super suite to create a form and have the contents emailed to an email address and also have the contents go to a MySQL database. I made the mistake of listing the zip code, age and phone number fields as INT. I changed them to VARCHAR. The zip code will not show any leading '0's. But the worst part is the phone number, which comes through in the email perfectly fine and formatted for the US (xxx)-xxx-xxxx, is coming through into the database as '0'. I have changed the data type to VARCHAR and even TEXT and still it just comes through as '0'. I have contacted the hosting company, who of course disavows andy responsibility as I am using "custom scripting". I dont know if this is a Form Builder error, Data Assist error or a mySQL issue.
My client is driving me crazy, anyone have any suggestions?