在插入之前数据是完整的但是插入到数据库中的数据却是不完整的sql语句是用的ibatis自动生成的插入语句 <insert id="ibatorgenerated_insert" parameterClass="com.gavin.sms.biz.generated.model.SMSWaitQueue" >
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Sat Jul 19 21:02:33 CST 2014.
-->
insert into g_sms_wait_queue (service_name, service_code, priority, path_id, content_length,
is_need_reply, send_time, mobile, msg_id, msg_count, resend_flag, resend_num, state,
create_date, update_date, content)
values (#serviceName:VARCHAR#, #serviceCode:VARCHAR#, #priority:INTEGER#, #pathId:BIGINT#,
#contentLength:INTEGER#, #isNeedReply:VARCHAR#, #sendTime:TIMESTAMP#, #mobile:VARCHAR#,
#msgId:VARCHAR#, #msgCount:INTEGER#, #resendFlag:VARCHAR#, #resendNum:INTEGER#,
#state:VARCHAR#, #createDate:TIMESTAMP#, #updateDate:TIMESTAMP#, #content:LONGVARCHAR#)
<selectKey resultClass="java.lang.Long" keyProperty="sid" >
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
列的属性如下主要是content这列为什么数据不完整求大神解救
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Sat Jul 19 21:02:33 CST 2014.
-->
insert into g_sms_wait_queue (service_name, service_code, priority, path_id, content_length,
is_need_reply, send_time, mobile, msg_id, msg_count, resend_flag, resend_num, state,
create_date, update_date, content)
values (#serviceName:VARCHAR#, #serviceCode:VARCHAR#, #priority:INTEGER#, #pathId:BIGINT#,
#contentLength:INTEGER#, #isNeedReply:VARCHAR#, #sendTime:TIMESTAMP#, #mobile:VARCHAR#,
#msgId:VARCHAR#, #msgCount:INTEGER#, #resendFlag:VARCHAR#, #resendNum:INTEGER#,
#state:VARCHAR#, #createDate:TIMESTAMP#, #updateDate:TIMESTAMP#, #content:LONGVARCHAR#)
<selectKey resultClass="java.lang.Long" keyProperty="sid" >
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
列的属性如下主要是content这列为什么数据不完整求大神解救
按下贴中的方法检查字符集设置。并贴出以供分析。
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码