Redshift Column Created as varchar showing up as Unicode

More
2 years 8 months ago #13904 by pmurphytc
pmurphytc created the topic: Redshift Column Created as varchar showing up as Unicode
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
2 years 8 months ago #13905 by Moderator
Moderator replied the topic: Re: Redshift Column Created as varchar showing up as Unicode
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.105 seconds
Powered by Kunena Forum