[SQL0330] Character conversion cannot be performed.

lvxinzhi

用jboss做中間層，數(shù)據(jù)端端maker，MODIFIER的 CCSID均為1388，在中間層新增數(shù)據(jù)時(shí)，一切正常，但在保存數(shù)據(jù)時(shí)出現(xiàn)以下錯(cuò)誤，請問是什么原因？

[SQL0330] Character conversion cannot be performed. Cause . . . . . :   An attempt was made to convert column or host variable *N to column or host variable MODIFIER.  The conversion cannot be performed. If the source data is character and has a mixed Coded Character Set Identifier (CCSID), then double-byte characters were found.  These mixed data conversions are only allowed if the source data does not contain any double-byte data.  If the data is graphic, the CCSID values are not compatible or the string contains single-byte characters. The source CCSID is 937, and the target CCSID is 1388. Recovery  . . . :   Ensure that all character or graphic comparison, concatenation, or assignment is between columns or host variables with compatible CCSID values.  If character data and the source CCSID is mixed, the source data should not contain any double-byte characters. If graphic data, the string cannot contain single-byte characters. Use a casting function like VARCHAR to convert between character, DBCS graphic, and Unicode graphic data.

新增數(shù)據(jù)的字符集為GBK，通過測試發(fā)現(xiàn)，把CCSID改為937，系統(tǒng)會(huì)保存成功，但會(huì)丟失部分中文

有人給指導(dǎo)一下嗎？

mxpy

先把表中原有的數(shù)據(jù)備份了，再用ALTER TABLE ALTER FIELD 將937的字段改成935或1388，然后將數(shù)據(jù)恢復(fù)回去

lvxinzhi

回復(fù) 2# mxpy


The source CCSID is 937, and the target CCSID is 1388

這句話說的是數(shù)據(jù)庫中的字符集是1388，
現(xiàn)在要更新的sql 語句里的數(shù)據(jù)CCSID字符集是937，
在java程序里，并沒有指定字符集,后臺(tái)數(shù)據(jù)庫表中的字段也沒有937
這個(gè)937是那里來的？

   

lvxinzhi

問題已經(jīng)解決
參考：http://blog.chinaunix.net/uid-200142-id-4308738.html

Server property	Description	Required	Choices	Default
package ccsid	Specifies the character encoding to use for the SQL package and any statements sent to the server.	"1200" (UCS-2)     "13488" (UTF-16)	no	13488