Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-34726

(NLSCHARSET06) %a string string
CAUTION: String truncated during character set conversion from %1p to %2p.
  • input_charset (%1p): The name of the input character set.
  • output_charset (%2p): The name of the output character set.

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 the 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 data type, then consider using the CHAR data type instead. If the byte limit is due to the limit of 4000 bytes per line of CHAR data, then break the long line into multiple lines.