<?xml version="1.0" encoding="windows-1252"?>
<node id="581926" title="DBI converting hex values" created="2006-11-02 12:15:07" updated="2006-11-02 07:15:07">
<type id="115">
perlquestion</type>
<author id="64446">
Sprad</author>
<data>
<field name="doctext">
I'm using DBI with the ODBC driver. In my DB, I have some hex values. I'd dearly like to leave them as hex values. Unfortunately, when I extract them, DBI assumes they're some sort of binary data and converts them to text.
&lt;p&gt;
For example, the hex string "0x5061756c" becomes the ASCII string "Paul". This is a documented feature of DBI, so the fact that it's doing this doesn't surprise me. What I'm wondering, though, is can I turn it off? I'd rather get the hex string as a literal "0x" followed by the literal hex digits.

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-64446"&gt;
&lt;p&gt;
&lt;font size = -1&gt;---&lt;br&gt;
A fair fight is a sign of poor planning.&lt;/font&gt;
&lt;/div&gt;&lt;/div&gt;</field>
</data>
</node>
