--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/plain; charset=ISO-8859-1
http://msdn.microsoft.com/en-us/library/ms714632(v=VS.85).as px
Using 8.4.2 driver on Windows
SQL_SUCCESS = SQLGetTypeInfo(StatementHandle = 0x36017c0,DataType
= SQL_ALL_TYPES)
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 1,TargetType = SQL_C_CHAR ,TargetValuePtr = 0x12c0b4,BufferLength =
1028,StrLen_or_IndPtr = 2084091336)
......
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=-1,data=(NULL)
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Using 9.0.01 driver on Windows
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=4,data=-5
<--------- DIFF
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div><a href=3D"http://msdn.microsoft.com/en-us/library/ms714632(v=3DVS.85)=
..aspx">http://msdn.microsoft.com/en-us/library/ms714632(v=3 DVS.85).aspx</a>=
</div><div><br></div>Using 8.4.2 driver on Windows<br><div><br></div><div><=
div>
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLGetTypeInfo(StatementHandle =3D 0x36=
017c0,DataType =3D SQL_ALL_TYPES)</div><div>SQL_SUCCESS =A0 =A0 =A0 =A0 =A0=
=3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 1,TargetTyp=
e =3D SQL_C_CHAR =A0 =A0 ,TargetValuePtr =3D 0x12c0b4,BufferLength =3D 1028=
,StrLen_or_IndPtr =3D 2084091336)</div>
<div>.....</div><div>SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLBindCol(Stateme=
nt Handle =3D 0x36017c0,ColumnNumber =3D 19,TargetType =3D SQL_C_SHORT =A0 =
=A0,TargetValuePtr =3D 0x12d544,BufferLength =3D 2,StrLen_or_IndPtr =3D 123=
0120)</div><div>SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLFetch(StatementHandl=
e =3D 0x36017c0)</div>
<div>=A0Row=3D0,TYPE_NAME =A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bu=
fLen=3D1028,size=3D4,data=3Dint8</div><div>=A0Row=3D0,DATA_TYPE =A0 =A0 =A0=
=A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5</div><div=
>=A0Row=3D0,COLUMN_SIZE =A0 =A0 =A0 =A0,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=
=3D4,size=3D4,data=3D19</div>
<div>=A0Row=3D0,LITERAL_PREFIX =A0 =A0 ,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)</div><div>=A0Row=3D0,LITERAL_SUFFIX =A0 =A0=
,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)</div><di=
v>=A0Row=3D0,CREATE_PARAMS =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D=
1028,size=3D-1,data=3D(NULL)</div>
<div>=A0Row=3D0,NULLABLE =A0 =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bu=
fLen=3D2,size=3D2,data=3D1</div><div>=A0Row=3D0,CASE_SENSITIVE =A0 =A0 ,Typ=
e=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div><div>=A0Row=3D0,S=
EARCHABLE =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,d=
ata=3D2</div>
<div>=A0Row=3D0,UNSIGNED_ATTRIBUTE ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,s=
ize=3D2,data=3D0</div><div>=A0Row=3D0,FIXED_PREC_SCALE =A0 ,Type=3DSQL_C_SH=
ORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div><div>=A0Row=3D0,AUTO_UNIQUE_V=
ALUE =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div>
<div>=A0Row=3D0,LOCAL_TYPE_NAME =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)</div><div>=A0Row=3D0,MINIMUM_SCALE =A0 =A0 =
=A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div><div>=A0Ro=
w=3D0,MAXIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=
=3D2,data=3D0</div>
<div>=A0Row=3D0,SQL_DATA_TYPE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=
=3D2,size=3D2,data=3D-5</div><div>=A0Row=3D0,SQL_DATETIME_SUB =A0 ,Type=3DS=
QL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D-1,data=3D(NULL)</div><div>=A0Row=3D0,=
NUM_PREC_RADIX =A0 =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=
=3D10</div>
<div>=A0Row=3D0,INTERVAL_PRECISION ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,s=
ize=3D2,data=3D0</div></div><div><br></div><div><br></div><div>Using 9.0.01=
driver on Windows</div><div><br></div><div><div>SQL_SUCCESS =A0 =A0 =A0 =
=A0 =A0 =3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 19,T=
argetType =3D SQL_C_SHORT =A0 =A0,TargetValuePtr =3D 0x12d544,BufferLength =
=3D 2,StrLen_or_IndPtr =3D 1230120)</div>
<div>SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLFetch(StatementHandle =3D 0x360=
17c0)</div><div>=A0Row=3D0,TYPE_NAME =A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_CHAR =
=A0 =A0 ,bufLen=3D1028,size=3D4,data=3Dint8</div><div>=A0Row=3D0,DATA_TYPE =
=A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-=
5</div>
<div>=A0Row=3D0,COLUMN_SIZE =A0 =A0 =A0 =A0,Type=3DSQL_C_LONG =A0 =A0 ,bufL=
en=3D4,size=3D4,data=3D19</div><div>=A0Row=3D0,LITERAL_PREFIX =A0 =A0 ,Type=
=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)</div><div>=A0R=
ow=3D0,LITERAL_SUFFIX =A0 =A0 ,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,siz=
e=3D-1,data=3D(NULL)</div>
<div>=A0Row=3D0,CREATE_PARAMS =A0 =A0 =A0,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=
=3D1028,size=3D-1,data=3D(NULL)</div><div>=A0Row=3D0,NULLABLE =A0 =A0 =A0 =
=A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D1</div><div>=
=A0Row=3D0,CASE_SENSITIVE =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,si=
ze=3D2,data=3D0</div>
<div>=A0Row=3D0,SEARCHABLE =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufL=
en=3D2,size=3D2,data=3D2</div><div>=A0Row=3D0,UNSIGNED_ATTRIBUTE ,Type=3DSQ=
L_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div><div>=A0Row=3D0,FIXED_P=
REC_SCALE =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div=
>
<div>=A0Row=3D0,AUTO_UNIQUE_VALUE =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2=
,size=3D2,data=3D0</div><div>=A0Row=3D0,LOCAL_TYPE_NAME =A0 =A0,Type=3DSQL_=
C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)</div><div>=A0Row=3D0,=
MINIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,da=
ta=3D0</div>
<div>=A0Row=3D0,MAXIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=
=3D2,size=3D2,data=3D0</div><div>=A0Row=3D0,SQL_DATA_TYPE =A0 =A0 =A0,Type=
=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5</div><div>=A0Row=3D0,S=
QL_DATETIME_SUB =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=3D=
-5 <--------- DIFF</div>
<div>=A0Row=3D0,NUM_PREC_RADIX =A0 =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=
=3D4,size=3D4,data=3D10</div><div>=A0Row=3D0,INTERVAL_PRECISION ,Type=3DSQL=
_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0</div></div><div><br></div>
--20cf301d3ed0df92eb04938d2fbc--
