Stored procedures inherit the UNICODE PASS THROUGH attribute of the session where 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