Apostrophe value in the data
Moderators: chulett, rschirm, roy
Re: Apostrophe value in the data
Changing the data type in SQL server ODBC stage from 'varchar' to 'nvarchar' fixed the problem.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This solutions suggests that it wasn't a real apostrophe but, probably, one of those allegedly "smart quotes" so beloved of Microsoft Office products, likely copied/pasted into whatever source your DataStage job was using.
These can be detected and handled, but it looks like you already have a solution that suits your purposes.
These can be detected and handled, but it looks like you already have a solution that suits your purposes.
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.