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