Redshift Column Created as varchar showing up as Unicode

  • pmurphytc
  • Topic Author
  • Visitor
  • Visitor
7 years 4 months ago #13904 by pmurphytc
Redshift Column Created as varchar showing up as Unicode was created 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
7 years 3 months ago #13905 by Moderator
Replied by Moderator on 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.153 seconds
Powered by Kunena Forum

Login Form

VM - Shopping cart

 x 

Cart empty