On Mon, Jun 28, 2010 at 10:28 PM, Paul Hastings <[email protected]> wrote: > > On 6/29/2010 2:28 AM, Rick Root wrote: >> wrapper is improperly translating the exclamation mark from the EBCDIC >> character set into ASCII - supposed to be ascii 33 but is coming >> through as ascii 93 instead. > > seen this? your exact problem is mentioned: > http://www.ibm.com/developerworks/data/library/techarticle/dm-0506chong/index.html > > does either driver support connection strings? can you add a codepage, i think > maybe "37" (just typing that makes my skin crawl)?
Thanks Paul... so far no luck. The StarSQL Driver has a connection string property called typdefovr that is used to define the CCSID (http://www.starquest.com/Products/starsql/ssqljava.pdf) I can save the datasource with values of "37" and "37,0,0" but neither has any effect. The StarSQL documentation does specifically sya it's for SENDING the data but doesn't specifically reference character translation for receiving data. I'll have to ask my mainframe guys to see what our default codepage is... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
