We have a table in our open edge database that contains a blob field (binary large object). A sister company of ours has an SQL application that reads this field. After upgrading to OpenEdge 10.2B (from 10.0C), they are having problems reading the data in the field. The code on their side takes the hexdec string of data from the blob field and converts it to a string field. In an effort to trouble shoot the problem, the developer in the SQL environment wants me to verify that the hex string he's seeing (which looks something like "202031303230333138344E444F2020202020203333393138353233303033202020324348412020202020202020363031353136203930303030342" )is the correct hex string. How can I view this string in the OpenEdge environment (either the appbuilder or even the old character progress editor)? By using the copy-lob function, I can view the actual data in the blob field, but he wants me to verify that the hex string he sees on his side is correct. How do I do that?
Thanks.
Jenni
Thanks.
Jenni