linux + tomcat + mysql + jsptomact - conf/server.xml 中 <Connector port="80" maxHttpHeaderSize="8192"
.............. URIEncoding="UTF-8" />mysql -
"Variable_name","Value"
"character_set_client","utf8"
"character_set_connection","utf8"
"character_set_database","latin1"
"character_set_results","utf8"
"character_set_server","latin1"
"character_set_system","utf8"
"character_sets_dir","/usr/share/mysql/charsets/""Variable_name","Value"
"collation_connection","utf8_general_ci"
"collation_database","latin1_swedish_ci"
"collation_server","latin1_swedish_ci"jsp -<%@ page language="java" contentType="text/html;charset=UTF-8"
.....
setURL("jdbc:mysql://127.0.0.1:3306/rrr");
.....
大概就是这个环境,不知道为什么不能插入中文,请指教,万分感谢~!请大家帮帮我了~!
.............. URIEncoding="UTF-8" />mysql -
"Variable_name","Value"
"character_set_client","utf8"
"character_set_connection","utf8"
"character_set_database","latin1"
"character_set_results","utf8"
"character_set_server","latin1"
"character_set_system","utf8"
"character_sets_dir","/usr/share/mysql/charsets/""Variable_name","Value"
"collation_connection","utf8_general_ci"
"collation_database","latin1_swedish_ci"
"collation_server","latin1_swedish_ci"jsp -<%@ page language="java" contentType="text/html;charset=UTF-8"
.....
setURL("jdbc:mysql://127.0.0.1:3306/rrr");
.....
大概就是这个环境,不知道为什么不能插入中文,请指教,万分感谢~!请大家帮帮我了~!
ALTER DATABASE `database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;在my.cnf里的[mysqld]下加default-character-set=utf8,重启mysql服务。这个是改库里某个表要插入中文的属性的字符集。
ALTER TABLE `表名` CHANGE `属性` `属性` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
其中的CHARACTER SET utf8 COLLATE utf8_bin 就是改字符集的。总之你把所有关于字符集的地方都改成utf8试试好了。
是在windows下"Variable_name","Value"
"character_set_client","utf8"
"character_set_connection","utf8"
"character_set_database","utf8"
"character_set_results","utf8"
"character_set_server","utf8"
"character_set_system","utf8"
"character_sets_dir","E:\MySQL Server\share\charsets\"
"Variable_name","Value"
"collation_connection","utf8_general_ci"
"collation_database","utf8_bin"
"collation_server","utf8_general_ci"
tomact - conf/server.xml 中 <Connector port="80" maxHttpHeaderSize="8192"
.............. URIEncoding="UTF8" />
.............................................................
小疑问:utf8 utf-8
怎么在这里是utf8 在网页里 page language="java" contentType="text/html;charset=UTF-8"
是utf-8
有的小混
tomact 里 这里 URIEncoding="UTF8" 是utf8 ?utf-8?
..............................................................在jsp
里可以插简体中文很正常,
<%@page contentType="text/html;charset=utf-8"%>
这展示中文也很正常,
不过插 繁体时就不行了javax.servlet.ServletException: Data truncation: Data too long for column 'test' at row 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.test1_jsp._jspService(test1_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)网页里的繁体中文也不能正常显示,
如果<%@page contentType="text/html;charset=gbk"%>
就可以正常显示,不过这样就不能插如中文 包括简体也不行