|Product:||Syniti Data Replication|
|Version:||Syniti Data Replication 9.6.0 and above|
|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.
To avoid errors and/or unexpected characters, set the datatype in the Redshift target to VARCHAR instead of CHAR.