fetches a column with datatype varying character as UNICODE

General PGNP discussions.

fetches a column with datatype varying character as UNICODE

Postby sashikanth.ratnala@gmail. » Tue Nov 16, 2010 11:50 pm

“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”
sashikanth.ratnala@gmail.
 
Posts: 2
Joined: Tue Nov 16, 2010 11:47 pm

Re: fetches a column with datatype varying character as UNICODE

Postby Moderator » Wed Nov 17, 2010 8:02 am

Yes, it is default behavior - provider convert utf8 into Unicode wide character string. Does that cause any issue?
User avatar
Moderator
Site Admin
 
Posts: 314
Joined: Wed Oct 29, 2008 11:27 pm

Re: fetches a column with datatype varying character as UNICODE

Postby sashikanth.ratnala@gmail. » Wed Nov 17, 2010 8:31 pm

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.
sashikanth.ratnala@gmail.
 
Posts: 2
Joined: Tue Nov 16, 2010 11:47 pm

Re: fetches a column with datatype varying character as UNICODE

Postby Moderator » Sat Nov 20, 2010 12:55 pm

We have created a ticket for this issue. It will be fixed in one of the future update releases.

Thank you!
PGNP Team
User avatar
Moderator
Site Admin
 
Posts: 314
Joined: Wed Oct 29, 2008 11:27 pm


Return to Miscellaneous

Who is online

Users browsing this forum: No registered users and 1 guest

cron