fetches a column with datatype varying character as UNICODE

  • sashikanth.ratnala@gmail.
  • Topic Author
  • Visitor
  • Visitor
11 years 6 months ago #626 by sashikanth.ratnala@gmail.
fetches a column with datatype varying character as UNICODE was created by sashikanth.ratnala@gmail.
“OLEDB provider for Green Plum when used in SSIS 2008 fetches a column with datatype varying character as UNICODE. Is this the expected behaviour?

Version of Provider is 1.3.0.2196”

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

More
11 years 6 months ago #627 by Moderator
Yes, it is default behavior - provider convert utf8 into Unicode wide character string. Does that cause any issue?

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

  • sashikanth.ratnala@gmail.
  • Topic Author
  • Visitor
  • Visitor
11 years 5 months ago #632 by sashikanth.ratnala@gmail.
Replied by sashikanth.ratnala@gmail. on topic Re: fetches a column with datatype varying character as UNICODE
When we are fetching data from Greenplum database using this driver to SQL Server, we have to use Data Conversion transformation to convert from unicode string to non unicode string ideally which is not advisable to use.

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

More
11 years 5 months ago #633 by Moderator
We have created a ticket for this issue. It will be fixed in one of the future update releases.

Thank you!
PGNP Team

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

Time to create page: 0.057 seconds
Powered by Kunena Forum