- From: Richard Cyganiak <richard@cyganiak.de>
- Date: Fri, 8 Jul 2011 11:05:01 +0100
- To: Kingsley Idehen <kidehen@openlinksw.com>
- Cc: public-rdb2rdf-wg@w3.org
Thanks Kingsley! That's very helpful. I just saw there is also a very detailed mapping from SQL types to XSD types in Section 9.5 of ISO/IEC 9075-14:2008, and a mapping from SQL values to XSD values in Section 9.8. It should be possible to work something out from these sources. Best, Richard On 7 Jul 2011, at 21:22, Kingsley Idehen wrote: > ODBC is the best basis for a collection SQL Types since all ODBC Drivers (provided by 3rd parties or RDBMS vendors) map to these from RDBMS specific types. Thus, if you need a collection of types for mapping to XSD you can grabs those used by ODBC. > > ODBC and JDBC are basically the standard SQL call level interfaces to all RDBMS engines. Their mappings [1] to ANSI SQL are also very clean. > > Links: > > 1. http://msdn.microsoft.com/en-us/library/ms710150(v=VS.85).aspx -- ODBC SQL Types > > -- > > Regards, > > Kingsley Idehen > President& CEO > OpenLink Software > Web: http://www.openlinksw.com > Weblog: http://www.openlinksw.com/blog/~kidehen > Twitter/Identi.ca: kidehen > > > > > >
Received on Friday, 8 July 2011 10:05:44 UTC