The behavior of the truncation depends upon whether the conversion occurs while the database is operating in Teradata mode or ANSI mode. For more information, see Truncation Exceptions in ANSI Mode and Truncation Exceptions in Teradata Mode.
| In this mode … | Truncation of this server character set is as follows … |
|---|---|
| ANSI | non-pad character data causes an error. |
| Teradata | character data is truncated without reporting an error. |