I am using Coldfusion to present DB2 data. My problem is that some of data is readable and some is not. I tried #ToString(encoding)# and REPLACE and still no luck. The ToString will only change the characters from boxes to something else. The REPLACE has not done anything. I am running my queries through Coldfusion and not at a DB2 console. Is there a quick fix to this? Hopefully someone out there has seen this.
Unfortunately, I can't see the data or the datatype pre-processing. In two different dbs I get funky data. If I use #ToString(column)# I get squares. Here is Access VB version: Select A.ORDNO, A.FITEM " _
& "FROM AMFLIBQ.MOMAST A INNER JOIN CD_COMDTA.DOMLP100 B ON (A.FITEM = B.LPITM#) " _
& "Where A.ORDNO = 'M" & strWorkOrder & "' And B.LPSTAT = 'A'"