If a procedure created in Teradata session mode is being replaced in ANSI session mode, it acquires the new session mode attributes and thereafter can only be performed in ANSI session mode.
Similarly, if a procedure created in ANSI session mode is replaced in Teradata session mode, it acquires the new session mode attributes and thereafter can only be performed in Teradata session mode.
You can replace an SQL procedure created with one default character set with a different default character set.