Hi All,
i have a DRS stage that is used for extracting data from sql server , couple of the columns are declared as nvarchar in the sql server database. i tried to define them as varchar and unicode as extended in the DRS stage but am receiving this error "[IBM(DataDirect OEM)][ODBC SQL Server Driver]Unicode conversion failed".
For a similar problem with another job i defined datatype as varchar and data element as Sql.guid and it worked but this time even this is not working.
can anyone please shed some light on this.
Thanks
Unicode conversion failed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 32
- Joined: Tue Dec 13, 2011 7:27 am
Re: Unicode conversion failed
I faced the same issue but with teradata. I changed NLS to ASCL_ISO8859-1 instead of (UTF-8) and it worked...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Unicode conversion failed
Can you explain why it worked?adityavinay wrote:I faced the same issue but with teradata. I changed NLS to ASCL_ISO8859-1 instead of (UTF-8) and it worked...
Can you be sure that it is a generic fix, or just a workaround?
Are you aware that there are 12 parts to ISO8859 ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 57
- Joined: Fri Feb 24, 2006 7:44 am
Re: Unicode conversion failed
Hi All,
The work around was replaced the DRS stage that was being used to read the data to a ODBC Connector and re-imported the metadata, had to import the metadata partially(10 at a time or so) but it worked.
Thanks
The work around was replaced the DRS stage that was being used to read the data to a ODBC Connector and re-imported the metadata, had to import the metadata partially(10 at a time or so) but it worked.
Thanks