The default precision for reading

or writing

string, text, or bytea data types is 32,000. If you configure a mapping to read

or write

data with the text, string, or bytea data types whose precision is more than 32,000, you must manually increase the precision of these data types in the mapping accordingly.

Citext data type is considered as case-sensitive text in the following scenarios:

When you configure a cached lookup and you define the lookup condition for the column of the Citext data type.
When you configure an Expression transformation for a column of the Citext data type.