Collation can affect the deletion of rows from tables defined with a character partitioning
expression.
If the collation for a table is either MULTINATIONAL or CHARSET_COLL and the definition
for the collation has changed since the table was created, Teradata Database aborts
any request that attempts to delete a row from the table and returns an error to the
requestor.
If a noncompressed join index with a character partitioning expression defined with
either an MULTINATIONAL or CHARSET_COLL collation sequence is defined on a table and
the definition for the collation has changed since the join index was created, Teradata
Database aborts any request that attempts to delete a row from the table and returns
an error to the requestor whether the operation would have deleted rows from the join
index or not.
The session mode and collation at the time the table was created need not match the
current session mode and collation for the delete operation to succeed.