Redshift Cast as VARCHAR changing last character


I am testing out Redshift and noticing that when casting a column as VARCHAR in Redshift, the final character in some rows is being altered.  After checking and rechecking the input, the data source is correct and the only change we are making is to cast as VARCHAR type.  We are unsure of why this would be occuring, and seems to have began over the past week.


  • ST_-Superman-_

    Can you provide an example along with the select statement you used in redshift?

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman