We've spoken to the vendor directly and they deny that any conversion takes
place in their JDBC driver. I believe them since we have applications
running against the same data using JDBC and also ODBC that do not fail.
When using JDBC directly we use the getBytes() method then convert each byte
one at a time...
I suspect there is a bug in the way that CFMX is converting the byte array
to a string.
Can anyone confirm or deny this?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Jared Clinton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 4:03 PM
To: CF-Talk
Subject: RE: CFMX - binary data in query
Bryan,
Every time I have seen this before, it is the fault of the database drivers
in question, not the CF engine.
Maybe?
Jared Clinton
NEC Australia
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 9:05 AM
To: CF-Talk
Subject: CFMX - binary data in query
Has anyone else had trouble retrieving and displaying binary data from a
database using CFMX?
If an Oracle column is defined as:
colName raw(2)
then you can insert data into that row like so:
INSERT INTO table
VALUES( '12AB' )
where 12AB represents 2 bytes (one hex number for every 4 bits)
But CFMX is doing something that causes it to be displayed funky after
retrieval even though it looks fine when I look directly in the DB.
Anyone know why??? Anyone?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
