aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-34726: (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string

ORA-34726: (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
Cause: Some operation required a string to be converted into a different character set. The string required more bytes in the new encoding, and exceeded some byte limit on its allowable length, causing some characters to be removed from the end of the string.
Action: If the byte limit is due to using the ID datatype, consider using the CHAR datatype instead. If the byte limit is due to the limit of 4000 bytes per line of CHAR data, break the long line up into multiple lines.

请先 登录 后评论

1 个回答

小智
ORA-34726:(NLSCHARSET06)注意:在字符集从字符串到字符串的转换期间,字符串被截断,
.原因:某些操作需要将字符串转换为不同的字符集。该字符串在新编码中需要更多字节,并且在其允许长度上超出了一些字节限制,导致从字符串末尾删除一些字符。,
.操作:如果字节限制是由于使用ID数据类型,请考虑使用CHAR数据类型。如果字节限制是由于每行CHAR数据的限制为4000字节,则将长行分为多行。,
.
请先 登录 后评论