fetches a column with datatype varying character as UNICODE

More
7 years 2 months ago #626 by sashikanth.ratnala@gmail.
sashikanth.ratnala@gmail. created the topic: fetches a column with datatype varying character as UNICODE
“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 2 months ago #627 by Moderator
Moderator replied the topic: Re: fetches a column with datatype varying character as UNICODE
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 2 months ago #632 by sashikanth.ratnala@gmail.
sashikanth.ratnala@gmail. replied the 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
7 years 1 month ago #633 by Moderator
Moderator replied the topic: Re: fetches a column with datatype varying character as UNICODE
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.397 seconds
Powered by Kunena Forum