Special Character endcoding for mysql, coldfusion
Posted on 2013-11-03
I'm having a issue with inputting utf-8 characters into the mySQL db. For example if I setup a form ...
<cfquery datasource="#request.dsn#" username="#request.dsnUsername#" password="#request.dsnPassword#">
INSERT INTO search
<form method="post" id="add_form" action="test.cfm" class="form-inline" accept-charset="ISO-8859-1">
<input name="search_terms" type="input">
<input name="submit" type="submit">
and I enter Japanese characters, I get テイ entered into the db column which is set at utf-8. I would like to have Japanese characters as the entry. If I manually enter it in using Navicat it enters just fine that way and displays them without them encoded.
Thanks for any help,