1366-Incorrect string value:'\xE5\x8D\xA1\xE5......' for column 'filename' at row 1
mysql数据库的一个问题，
mysql的列可以控制字符集的，也就是字符集编码的问题，当你在设计数据库的时候搞错了的时候，比如中文的东西你搞成，latin1
后就会报如下的错误的，如果这列数据会出现这样的错误，你最好把这列的字符集设置为utf8校对，选则utf8_general_ci.
具体字符集对应哪个国家的鸟语，自己要对应一下。百度一下。

例如，由于这个原因导致的程序报的错误。：
16:44:01,897 WARN  [Thread-60] [JDBCExceptionReporter] SQL Error: 1366, SQLState: HY000
16:44:01,899 ERROR [Thread-60] [JDBCExceptionReporter] Incorrect string value: '\xE6\x96\xB0\xE7\x96\x86...' for column 'filename' at row 1
16:44:01,899 ERROR [Thread-60] [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
 at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:420)
 at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
 at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:690)
 at com.sys.dao.BaseImpl.save(BaseImpl.java:120)
 at com.sys.util.ZkUtil.upLoadFile(ZkUtil.java:540)
 at com.email.WriteEmail.saveOk(WriteEmail.java:129)
 at org.zkoss.comp.ui.wnd.RecWnd.setStatus(RecWnd.java:344)
 at org.zkoss.comp.ui.wnd.ChildWnd.setStatus(ChildWnd.java:426)
 at com.sys.util.ZkUtil.save(ZkUtil.java:503)
 at com.email.WriteEmail.sendEmail(WriteEmail.java:159)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.zkoss.comp.ui.wnd.AppWnd.onEvent(AppWnd.java:493)
 at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2699)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2670)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2611)
 at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:534)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:461)
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE6\x96\xB0\xE7\x96\x86...' for column 'filename' at row 1
 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2016)
 at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
 ... 27 more
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into s_document (filename, tablename, dataid, filepath, savename) values (?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE6\x96\xB0\xE7\x96\x86...' for column 'filename' at row 1; nested exception is java.sql.BatchUpdateException: Incorrect string value: '\xE6\x96\xB0\xE7\x96\x86...' for column 'filename' at row 1
 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
 at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
 at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
 at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
 at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:690)
 at com.sys.dao.BaseImpl.save(BaseImpl.java:120)
 at com.sys.util.ZkUtil.upLoadFile(ZkUtil.java:540)
 at com.email.WriteEmail.saveOk(WriteEmail.java:129)
 at org.zkoss.comp.ui.wnd.RecWnd.setStatus(RecWnd.java:344)
 at org.zkoss.comp.ui.wnd.ChildWnd.setStatus(ChildWnd.java:426)
 at com.sys.util.ZkUtil.save(ZkUtil.java:503)
 at com.email.WriteEmail.sendEmail(WriteEmail.java:159)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.zkoss.comp.ui.wnd.AppWnd.onEvent(AppWnd.java:493)
 at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2699)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2670)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2611)
 at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:534)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:461)
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE6\x96\xB0\xE7\x96\x86...' for column 'filename' at row 1
 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2016)
 at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
 at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:420)
 ... 20 more
java.lang.NullPointerException
 at com.email.WriteEmail.saveOk(WriteEmail.java:130)
 at org.zkoss.comp.ui.wnd.RecWnd.setStatus(RecWnd.java:344)
 at org.zkoss.comp.ui.wnd.ChildWnd.setStatus(ChildWnd.java:426)
 at com.sys.util.ZkUtil.save(ZkUtil.java:503)
 at com.email.WriteEmail.sendEmail(WriteEmail.java:159)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.zkoss.comp.ui.wnd.AppWnd.onEvent(AppWnd.java:493)
 at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2699)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2670)
 at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2611)
 at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:534)
 at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:461)
2012-3-9 16:44:01 org.zkoss.zk.ui.impl.UiEngineImpl handleError:1348
严重: >>org.hibernate.TransactionException: Transaction not successfully started
>> at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
>> at com.sys.util.ZkUtil.save(ZkUtil.java:507)
>> at com.email.WriteEmail.sendEmail(WriteEmail.java:159)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>> at org.zkoss.comp.ui.wnd.AppWnd.onEvent(AppWnd.java:493)
>> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2699)
>> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2670)
>> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2611)
>> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>> at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:534)
>> at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:461)