Can anyone tell me what causes a Unicode Conversion Error.
I'm simply taking data from a flat file and loading it into SQL Server. The data contains a mixture of data types.
Thanks
Shay
Unicode Conversion Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Usually that error stems from having an incorrectly specified Unicode map when running DataStage with NLS enabled.
Another possibility is that the SQL Server data type is NVARCHAR or NCHAR and you're feeding it a character that it can't map using Microsoft's idea of a Unicode map.
Another possibility is that the SQL Server data type is NVARCHAR or NCHAR and you're feeding it a character that it can't map using Microsoft's idea of a Unicode map.
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.