comment on

All, I am using Perl 5.8.8 on Ubuntu Server 8.04, with DBD::ODBC, and FreeTDS. The database is on a WinNT server, running MS SQL Server 2000. Here is my pseudo-query:

SELECT row_guid FROM table
[download]

What should come back is this:
DAD26152-1C43-11DD-BD0B-0800200C9A66

What does come back is this:
RaÒÚCİ½

Is perl somehow reading this as hex or something?

Do I need to (un)pack somehow?

Any help will be greatly appreciated.

Thanks!

Kevin J

In reply to GUIDs returned as gibberish (ODBC/MS SQL) by LaidBackWebSage

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Problems? Is your data what you think it is?
	PerlMonks