I know it's usually pretty pointless to post my DB2 issues to cf-talk but it's always worth a shot.
I have an issue (64 bit coldfusion 8.0.1 multi-server on Win2k8) where, if I do a simple query to our DB2 mainframe database, the exclamation mark character in any string fields is returned as a right closing bracket instead. I believe this is because the driver or 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. I think this might be specific to coldfusion's JDBC wrapper, because it occurs when I use the built in JDBC driver (from Data Direct, I think), as well as a third party JDBC driver that we purchased (StarSQL DB2). I suspect I need to call Adobe on this, but thought I'd hit the list first. 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:334895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
