| Product: | Syniti Data Replication |
| Version: | Syniti Data Replication 9.6.0 and above |
| ID: | 3014 |
| Summary: | Replicate to Redshift with VARCHAR instead of CHAR to support more characters and avoid introduction of unexpected characters |
Errors or unexpected characters can appear in fields with datatype CHAR when replicating to Amazon Redshift cloud data warehouse. For an explanation of this phenomenon, see the following article.
https://docs.amazonaws.cn/en_us/redshift/latest/dg/multi-byte-character-load-errors.html
To avoid errors and/or unexpected characters, set the datatype in the Redshift target to VARCHAR instead of CHAR.