fwiw, I also tried code pages 437 ("MS-DOS United States, Australia,
New Zealand, South Africa") and code page 1047 ("Latin-1 character set
for EBCDIC hosts").Cp1047 returned the same result.. Cp437 caused a null null error. Rick On Tue, Jun 29, 2010 at 8:06 AM, Rick Root <[email protected]> wrote: > 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:334920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
