How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

DB2 - CHAR () FOR BIT DATA

[This topic is migrated from our old forums. The original author name has been removed]

I'm running a query against a DB2 table that has several fields with the format of "CHAR () FOR BIT DATA".  In the results set the values for those colums are coming back in the form of "f1f1f4f0f9f140404040404040404040404040404040404040".  I'm able to filter on the column with the real value, 114091, but I can't get the real value to display.  I've gone into the Tool Properties window and on the Binary/BLOB and CLOB Data window selected By Value for both Binary/BLOB and CLOB data.  How do I get the data to display correctly?
1 Comment
[This reply is migrated from our old forums.]

Re: DB2 - CHAR () FOR BIT DATA
Hi, We will add a [b]Convert FOR BIT DATA to Text[/b] in the next version that will solve this by letting the user decide how these data types should be presented. This will also be part of the next early access release (5.1.1.4). Check this page for 5.1.1.4 during the next 12 hours: http://www.minq.se/products/dbvis/eap Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics