SQL Server field metadata issue

MartyN · Post by **MartyN** » Wed 25 Apr 2012 21:22

When I use the TUniMetaData component to retrieve field information from a SQL Server 2008 R2 database the the field name and position are correct but the user_type_id is the wrong number.
data type - integer sys.type - 56 metadata - 3
data type - varchar sys.type - 167 metadata - 129

what's going on here?

AlexP · Post by **AlexP** » Thu 26 Apr 2012 08:43

Hello,

To obtain metadata, we use OLEDB-interfaces instead of explicit queries from the system tables (sys.columns, sys.types). Therefore, in metadata, the OLEDB values of types, that correspond MSSQL internal types, are shown.