When comparing character strings, data characters must have the same server character set. If they do not, then the system translates them using the implicit translation rules described in "Implicit Character-to-Character Conversion" in Teradata Vantage™ - Data Types and Literals, B035-1143.