DSXchange

We've determined (via SQL doing a CONVERT(VARBINARY() as well as UltraEdit doing a HEX dump, and via online ASCII/HEX/Decimal calculator converters) the Decimal value of the character is 146, the HEX value is 92. For some odd reason, DataStage doesn't recognize the Decimal value 146. It does recogni...

I also added a peek stage and when I view the data in Director it displays that character as: ?

I tried to identify the Decimal 8217 and DataStage is having a problem with what I'm entering:
if IsNull(DSLink5.DESCRIPTION) then Space(1) else Convert(UniChar(8217):Char(10):Char(11):Char(13),' ',DSLink5.DESCRIPTION)

I tried all of the below Decimal values which resemble the apostrophe symbol I'm seeing and my transformer is replacing the value with a small square box into the extracted txt file: if IsNull(DSLink5.DESCRIPTION) then Space(1) else Convert(Char(146):Char(145):Char(130):Char(31):Char(44):Char(96):Ch...

if IsNull(DSLink5.DESCRIPTION) then Space(1) else Convert(Char(92),' ',Convert(Char(41),' ', Convert(Char(10),' ',Convert(Char(11),' ',Convert(Char(13),' ',DSLink5.DESCRIPTION)))))

I read through a variety of posts that discuss converting ASCII characters to a HEX value in DataStage and have not been able to find my specific issue. I am extracting data (ODBC connector) which is coming from a Siebel database where there is a character that appears to look like an apostrophy, ho...