Transformation language functions can handle character data in either ASCII or Unicode data movement mode. Use Unicode mode to handle

multibyte

character data. The return values of the following functions and transformations depend on the code page of the

PowerCenter Integration Service

and the data movement mode:

MIN and MAX also return values based on the sort order associated with the

PowerCenter Integration Service

code page.

When you validate an invalid expression in the Expression Editor, a dialog box displays the expression with an error indicator, “>>>>”. This indicator appears to the left of and points to the part of the expression containing the error. For example, if the expression a = b + c contains an error at c, the error message displays:

Transformation language functions that evaluate character data are character-oriented, not byte-oriented. For example, the LENGTH function returns the number of characters in a string, not the number of bytes. The LOWER function returns a string in lowercase based on the code page of the

PowerCenter Integration Service

.