Redshift Column Created as varchar showing up as Unicode

More
5 years 3 months 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
5 years 3 months 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.042 seconds
Powered by Kunena Forum