fetches a column with datatype varying character as UNICODE

More
7 years 2 days ago #626 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
7 years 1 day 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.

More
7 years 1 day ago #632 by sashikanth.ratnala@gmail.
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
6 years 11 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.140 seconds
Powered by Kunena Forum