ODBC: Mapping of literal type names in create table statements
- by matthias-meyer
I was wondering if data types in a a literal "create table" statement, executed over ODBC, are replaced with their database specific counterparts (platform is Windows/.Net/C#).
I cannot find this feature in the ODBC docs, and there seems to be no list of literal "ODBC data types". However, I know that this works for Oracle, SQL Server and Access; the following statement is executed correctly, although the type LONGVARBINARY is no native type in all of these systems:
CREATE TABLE (MYCOLUMN LONGVARBINARY)
However, e.g. for Oracle the mapped native type depends on the used ODBC driver.
Is this an undocumented feature? Is there a list of supported type names anywhere?
Thanks!