LaidBackWebSage has asked for the wisdom of the Perl Monks concerning the following question:
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
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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: GUIDs returned as gibberish (ODBC/MS SQL)
by graff (Chancellor) on Oct 27, 2008 at 01:36 UTC | |
Re: GUIDs returned as gibberish (ODBC/MS SQL)
by CountZero (Bishop) on Oct 27, 2008 at 06:02 UTC | |
Re: GUIDs returned as gibberish (ODBC/MS SQL)
by pKai (Priest) on Oct 27, 2008 at 11:15 UTC | |
by massa (Hermit) on Oct 27, 2008 at 12:55 UTC | |
by LaidBackWebSage (Acolyte) on Oct 27, 2008 at 14:09 UTC | |
Re: GUIDs returned as gibberish (ODBC/MS SQL)
by Krambambuli (Curate) on Oct 27, 2008 at 09:31 UTC | |
Re: GUIDs returned as gibberish (ODBC/MS SQL)
by mje (Curate) on Oct 27, 2008 at 09:19 UTC |
Back to
Seekers of Perl Wisdom