Devart Forums

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?

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.