cfupdate/cfinsert invalid date string error with mysql varchar field
I recently had up set up a new development laptop on which I use CF and mySQL. I have had this application running for almost 10 years on various versions without a problem, but this is the first install on a Windows 10 machine (don't know how Windows 10 would affect this, but that is the only difference).
After getting everything set up and running I came across a weird error and am wondering if anyone else has seen it.
I have information I collect in which I need to encrypt a date of birth and store it. I have this field in the database as a VARCHAR, not a date. However, on the new machine, when trying to update or insert with cfupdate/cfinsert, I receive an error that the encrypted value is not a valid date or time string. This happens even if I remove any validation of a valid date format and just leave it strictly as a text value.
I am able to manually code an SQL update/insert which is accepted, so that would make me believe it is a CF issue, however, I am also able to create a new table with a single VARCHAR field and use the same exact CF code to insert the same encrypted date values without error, which makes me think it's mySQL table related.
Having a work around I'm not in a bind, however I am curious if anyone else has seen it and knows why it's happening. I am absolutely stumped as to why the system is seeming to read this VARCHAR field as a DATE field when trying to insert or update.
Any thoughts would be greatly appreciated!
