Okay, an article I found said to run this query: SELECT ENCODING_SCHEME FROM SYSIBM.SYSTABLES WHERE NAME = 'ADVTB901'
And if the result is E then it uses the parameter values of SCCID, MCCGID, and GCCID for single byte, multi-byte, and graphic character sets. So it looks like the code page were using is code page 500 (which contains all Latin 1 characters) However, setting the codepage to 500 (or 500,0,0) in the connection string using the typdefovr doesn't seem to help either. :( R ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:334936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
