Question
insert chinese big5 characters into database
database: mysql
default charset of web page: utf-8 (specified in apache, all pages are in utf-8)
if I enter english, database insert is ok but if I enter chinese, error = "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?)' at line 1"
display inputted fields are OK.
*** form.cfm ***
<form action="insert.cfm" method="post">
name: <input type="text" name="name" value=""><BR>
Password: <input type="text" name="password" value=""><BR>
<input type="submit" name="login_user" value="insert"><BR>
</form>
*** insert.cfm ***
<cfoutput>
#Form.name#<Br>
#form.password#<br>
</cfoutput>
<cfquery name="insert" datasource="test">
insert into test (name,password) values ('#Form.name#', '#Form.password#')
</cfquery>
default charset of web page: utf-8 (specified in apache, all pages are in utf-8)
if I enter english, database insert is ok but if I enter chinese, error = "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?)' at line 1"
display inputted fields are OK.
*** form.cfm ***
<form action="insert.cfm" method="post">
name: <input type="text" name="name" value=""><BR>
Password: <input type="text" name="password" value=""><BR>
<input type="submit" name="login_user" value="insert"><BR>
</form>
*** insert.cfm ***
<cfoutput>
#Form.name#<Br>
#form.password#<br>
</cfoutput>
<cfquery name="insert" datasource="test">
insert into test (name,password) values ('#Form.name#', '#Form.password#')
</cfquery>
AdChoices