- 论坛徽章:
- 4
|
用jboss做中间层,数据端端maker,MODIFIER的 CCSID均为1388,在中间层新增数据时,一切正常,但在保存数据时出现以下错误,请问是什么原因?
[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.
新增数据的字符集为GBK,通过测试发现,把CCSID改为937,系统会保存成功,但会丢失部分中文
有人给指导一下吗? |
|