Consider the following rules and guidelines for PostgreSQL data types:
•The default precision for reading or writing bytea, JSONB, string, or text data types is 32,000. If you configure a mapping to read or write data with the bytea, JSONB, string, or text data types whose precision is more than 32,000, you need to 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.