Hi all,

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.

Thanks in advance,

DJ Khalif

Use DB2 casting functions
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

I tried CAST and DECIMAL and neither worked. Do you have an example? Also, I have a column name that contains # and when I write the string, Coldfusion considers this an expression.

The link above is for DB2 LUW 9.5

Use this link to choose the Information center accordingly to your version:
IBM - DB2 database product documentation

djkhalif, What version of DB2 and what operating system are you using?

Can you give an example of the data before the conversion and what you want it to look like after?

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'"

ByteArray objects cannot be converted to strings. Without ToString.

utf-8 cannot be converted to a number. These are the error messages that I get.