
Win32:ODBC and Microsoft's SQL Server 6.5
F.Y.I. We just upgraded our MS SQL Server from 6.0 to 6.5, and
Microsoft gave us a sweet little kiss. Microsoft changed the values
returned from the SP_FKEYS, SP_PKEYS, and SP_COLUMNS calls from
all lowercase to all uppercase. And, man, does that ever reck
havok on the hash/associative arrays we use in Perl. When the
returned values are used as KEYS in hash and you try to access
an entry using the key name as returned in 6.0, you get an
undef back.
The scary part is that Microsoft may decide to play with the
case in future releases too. Bummer.
One work around though (Larry Wall, are you reading this?) would
be to have a flag you can set to tell PERL to ignore case for
keys used in associative arrays.
Anyway, if you are planning on upgrading to MS SQL 6.5 and you use
Win32:ODBC in PERL, you might want to check your code for stored
procedure calls.
Have fun!
-Douger