在MYSQL中查询show variables like '%char%';结果如下:character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir D:\MySQL Server 5.0\share\charsets\context.xml内容如下:
<?xml version='1.0' encoding='utf-8'?>
<Context>
<Resource name="jdbc/survey"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/survey"
username="hzh" password="123456" maxActive="200" maxIdle="10"
maxWait="-1"
useUnicode="true"
characterEncoding="utf-8"
/>
</Context>html页面字符集设置如下:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
... ...但是在submit页面内容后,向MYSQL插入的数据是乱码,重起tomcat 和 mysql 后还是一样,请问还漏了哪里没有设置吗??谢谢
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir D:\MySQL Server 5.0\share\charsets\context.xml内容如下:
<?xml version='1.0' encoding='utf-8'?>
<Context>
<Resource name="jdbc/survey"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/survey"
username="hzh" password="123456" maxActive="200" maxIdle="10"
maxWait="-1"
useUnicode="true"
characterEncoding="utf-8"
/>
</Context>html页面字符集设置如下:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
... ...但是在submit页面内容后,向MYSQL插入的数据是乱码,重起tomcat 和 mysql 后还是一样,请问还漏了哪里没有设置吗??谢谢
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="SpryAssets/SpryValidationCheckbox.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationCheckbox.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.tagtitle {
font-weight: bold;
}
-->
</style></head><body>
<table>
<tr>
<td>
<p class="tagtitle">一、点评者基本情况(请将您的身份在下列身份标识前打钩,如同时具有多种身份,可在多个身份标识前打勾)</p>
<form name="form9" action="../servlet/QListManager.do?op=add" method="post" onSubmit="return CheckForm();><span class="tagtitle">年龄:</span>1.
<input name="checkbox1" type="checkbox" id="checkbox1" value="35周岁及以下" />
35周岁及以下 2.
<input name="checkbox2" type="checkbox" id="checkbox2" value="36-45周岁" />
36-45周岁 3.
<input name="checkbox3" type="checkbox" id="checkbox3" value="46-60周岁" />
46-60周岁 4.
<input name="checkbox4" type="checkbox" id="checkbox4" value="61周岁及以上" />
61周岁及以上
<p> <span class="tagtitle">性别:</span>1.
<input name="checkbox5" type="checkbox" id="checkbox5" value="男" />
... ...