On 22/12/12 17:56, Lyle wrote:
On 22/12/2012 09:14, Tim Bunce wrote:
I have a copy of the SQL:2011 standard, yet I cannot seem to find a
list of numbers correlating to data types? Is this DBI specific? Is
it still supported? Am I missing something?
It's not DBI specific. I've attached the copy I have.
Thanks. This has led me to the relevant section of the 2011 (which is the same
as 2008) SQL/CLI page 80:
Table 7, "Codes used for implementation data types in SQL/CLI", specifies
the codes associated with the
SQL data types used in implementation descriptor areas.
Now my current challenge is finding the ODBC definitions, which has thus far
been unfruitful. I've been right through the current ODBC documentation:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms710252%28v=vs.85%29.aspx
Failing that, tried finding the ODBC SDK. Searches in MSDN downloads only
seemed to turn up MDAC:
http://www.microsoft.com/en-us/download/details.aspx?id=21995
Which didn't include the header files mentioned here (which I assume must
contain the codes I seek):
http://msdn.microsoft.com/en-us/library/windows/desktop/ms713603%28v=vs.85%29.aspx
I did manage to find some second hand references to ODBC data type codes from
SQL Server 2000:
http://msdn.microsoft.com/en-us/library/aa179135%28v=SQL.80%29.aspx
and open XML:
http://msdn.microsoft.com/en-us/library/office/documentformat.openxml.spreadsheet.parameter.aspx
On google I found some notes from Denis Box at Fermilab USA, who had the same
troubling finding them (interesting as he references your book as the only
place he could find them):
http://home.fnal.gov/~dbox/SQL_API_Portability.html
... Ah, found a copy of the header files, they come with the Windows 7 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=3138
By default it'll try to install all sorts, but you only need to select the
header files. sqlext.h contains the ODBC SQL extended datatype codes.
You can just download a recent unixODBC source tar ball and you'll find all the
headers in there. They won't be identical to the ones on Windows but the ODBC
constants should be.
ftp://ftp.unixodbc.org/pub/unixODBC/
I'm still doing this post because:
A) Others who get stuck looking for this may find this post. Google brings up
the DBI archives quite a lot for non DBI specific searches on this kind of thing
B) Checking the header file doesn't seem like the ideal solution. Somebody
might know of an official MS resource where this is properly defined?
If I can help with this, let me know, I can submit patches.
I'd be delighted to get patches updating those. Thanks!
Working on it. If no one comes back with a better resource, should I add a
description of how to find the ODBC codes from the header files?
Lyle
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
