聽聽@Lob
聽聽@Column(columnDefinition聽=聽"LongBlob")
聽聽public聽byte[]聽getContent()聽{
聽聽聽聽return聽content;
聽聽}
涓寮濮嬶紝閰嶇疆mysql jdbc url濡備笅
jdbc.url聽聽聽聽聽聽聽聽聽聽聽聽=聽聽聽聽jdbc:mysql://localhost/test\
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽?useUnicode=true\
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽&characterEncoding=gbk
涓嫻嬭瘯錛屾姤閿?br />Caused聽by:聽java.sql.BatchUpdateException:聽Syntax聽error聽or聽access聽violation聽message聽from聽server:聽"You聽have聽an聽error聽in聽your聽SQL聽syntax聽near聽''D0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000'聽at聽line聽1"
聽聽聽聽at聽com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1540)
鍚屾牱鐨勮鍙ワ紝鐩存帴鍦╩ysql鍛戒護琛屼笅榪愯灝辨病闂錛屽亸鍋廽dbc涓婂氨鏈夎繖鑷瘺鐥呫傛崲jdbc driver鐗堟湰錛屾敼@Lob涓?@Type(type = "org.springframework.orm.hibernate3.support.BlobByteArrayType")錛屾敼hibernate閰嶇疆錛堟瘮濡俬ibernate.jdbc.use_streams_for_binary true錛夛紝鐢氳嚦鏄洿鎺ョ敤jdbc鏉nsert錛屼貢涓冨叓緋熸姌鑵懼崐澶╋紝闂鐓ф棫銆傛渶鍚庡彧濂界敤涓娾滄鈥濇嫑錛屾妸byte[]閰嶆垚String錛屽湪淇濆瓨鐨勬椂鍊欐妸byte[]淇濆瓨鎴恏ex String鏍煎紡錛屽彇鐨勬椂鍊欏啀瑙g爜鍥炴潵銆?br />
姝嫑緇堝綊鏄鎷涳紝榪欎袱澶╄佷負榪欎笢瑗垮績鐑︼紝鏅氫笂鍚冮キ鐨勬椂鍊欐棤鎰忎腑鎯寵搗charset鐨勯棶棰橈紝鎶婁唬鐮佹崱鍥炴潵鍐嶆祴璇曚簡涓涓嬶紝闂瑙e喅錛屽搱鍝堬紒
jdbc.url聽聽聽聽聽聽聽聽聽聽聽聽=聽聽聽聽jdbc:mysql://localhost/mmwy_blog\
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽?useUnicode=true\
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽&characterEncoding=utf-8
濡傛灉璁炬垚iso-8859-1銆乽tf-8,淇濆瓨涓鐐歸棶棰橀兘娌℃湁錛屾崲鐢╣bk銆乬b2312銆乥ig5涔嬬被鐨勫瓧絎﹂泦錛岄棶棰樺氨鍑烘潵浜嗐?br />

]]>