Redshift Column Created as varchar showing up as Unicode

  • pmurphytc
  • Topic Author
  • Visitor
  • Visitor
6 years 2 weeks ago #13904 by pmurphytc
I have a table in redshift with columns that i created as varchar. These are showing up as a unicode string (DT_WSTR) in SSIS causing casting issues.

Has anyone encountered this?

Thanks.

Paul

Please Log in or Create an account to join the conversation.

More
6 years 1 week ago #13905 by Moderator
Yes, this is by design. All character types in Postgres/Redshift/Greenplum are exposed as Unicode. This is mostly because Windows natively supports UTF-16.

There are workarounds that allow handling the WSTR conversion issues.

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum