Apostrophe value in the data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kinu008
Premium Member
Premium Member
Posts: 36
Joined: Fri Mar 16, 2007 1:35 pm

Re: Apostrophe value in the data

Post by kinu008 »

Changing the data type in SQL server ODBC stage from 'varchar' to 'nvarchar' fixed the problem.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

8)

Thanks for posting your resolution.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, definitely not a single quote / apostrophe but rather some flavor of "smart quote" as noted. Had planned on mentioning that earlier but forgot.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply