The behavior of the truncation depends on 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.
| Mode | Truncation of Server Character Set |
|---|---|
| ANSI | Non-pad character data causes an error. |
| Teradata | Character data is truncated without reporting an error. |