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