Stored procedures inherit the Unicode Pass Through attribute of the session in which they are created:
| Setting | Unicode Pass Through |
|---|---|
| S | On for the session |
| F | Off for the session. |
The following output shows that Unicode Pass Through was set to on for the session that created the procedure.
HELP PROCEDURE sp1 ATTRIBUTES;
*** Help information returned. One row.
Transaction Semantics TERADATA
Print Mode N
Platform LINUX
Character Set ASCII
Default Character DataType LATIN
Collation ASCII
SPL Text Y
Version Number 11
Default Database USER2
Warning Option Y
Creation Timezone 00:00
Creation Timezone String
Unicode Pass Through S