some forms submitted from Asia not populating database.
Posted: Wed Oct 21, 2009 3:28 pm
I have a form that populates a database. The script emails a confirmation to the applicant as well as to our staff right after the database submission. Most, but not all, of the submissions from Japan and Vietnam fail to populate the database. We know this because the confirmation emails do go through.
The database is mySQL 5.1, located at Network Solutions.
I can't for the life of me replicate the problem. It isn't appropriate for me to question the applicants about their submissions (most wouldn't speak English anyway) so I can't gain clues that way. Values are processed through mysql_real_escape_string. Submissions may include Vietnamese, Chinese, or Japanese characters.
Has anyone else run into such a problem? Any thoughts on issues to investigate.
The database is mySQL 5.1, located at Network Solutions.
I can't for the life of me replicate the problem. It isn't appropriate for me to question the applicants about their submissions (most wouldn't speak English anyway) so I can't gain clues that way. Values are processed through mysql_real_escape_string. Submissions may include Vietnamese, Chinese, or Japanese characters.
Has anyone else run into such a problem? Any thoughts on issues to investigate.