CHAR or VARCHAR
C / C++ / MFC
3
Posts
3
Posters
2
Views
1
Watching
-
I am using SQL Server and VC++ 2005. How to know programatically whether column type of a particular field is CHAR or VARCHAR using OLEDB or ODBC?
i believe that value you are retrieving from database in a "variant" variable if so then you can differintiate using the variant type types are:- BSTR FAR* pbstrVal; // VT_BYREF|VT_BSTR. for varchar char cVal; // VT_I1. for char
Regards, Pankaj Sachdeva "There is no future lies in any job" "but" "future lies in the person who holds the job"
-
I am using SQL Server and VC++ 2005. How to know programatically whether column type of a particular field is CHAR or VARCHAR using OLEDB or ODBC?
With ODBC, you can use SQLColumns() Mark
Mark Salsbery Microsoft MVP - Visual C++ :java: