The following Teradata attribute functions are extensions to the ANSI SQL:2011 standard:
| Teradata Function | ANSI Function |
|---|---|
| CHARACTERS CHARS CHAR |
CHARACTER_LENGTH |
| MCHARACTERS† | |
| † This function is no longer documented because its use is deprecated and its support ends when KANJI1 support ends. | |
To maintain ANSI compatibility, use the ANSI equivalent functions instead of Teradata attribute functions, when available. The following table shows how to change the Teradata function to the ANSI function in new applications.
The following Teradata functions have no ANSI equivalents:
- BYTES
- FORMAT
- TYPE