Odbc - binding sql server binary field to a wide char field only returns 1/2 the daat

[John H]

Hi ,
Have a Visual C++ app that use odbc to access sql server database.
Doing a select to get value of binary field and bind a char to that
field as follows , field in database in binary(16)

char lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_C_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);

and this works fine , however trying to move codebase to UNICODE an
tested the following

WCHAR lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_W_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);
but only returns 1/2 the data .

Any ideas , thoughts this would work fine , nit sure why loosing data
All ideas welcome.

JOhn

[Erland Sommarskog]

John H (jj*******@yahoo.co.uk) writes:

Have a Visual C++ app that use odbc to access sql server database.
Doing a select to get value of binary field and bind a char to that
field as follows , field in database in binary(16)

char lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_C_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);

and this works fine , however trying to move codebase to UNICODE an
tested the following

WCHAR lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_W_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);
but only returns 1/2 the data .

Looking in the MDAC Books Online, I see that the fourth argument is a
size in bytes. Thus for Unicode, you say 2 * RESOURCE_ID_LEN_PLUS_NULL.
(Make sure that your buffer is also that size!)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[John H]

Hi,
Thanks very much.
Should have figured it out myself!.

JOhn
Erland Sommarskog wrote:

John H (jj*******@yahoo.co.uk) writes:

Have a Visual C++ app that use odbc to access sql server database.
Doing a select to get value of binary field and bind a char to that
field as follows , field in database in binary(16)

char lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_C_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);

and this works fine , however trying to move codebase to UNICODE an
tested the following

WCHAR lpResourceID[32+1];
rc = SQLBindCol(hstmt, 1, SQL_W_CHAR, &lpResourceID,
RESOURCE_ID_LEN_PLUS_NULL , &nLen1);
but only returns 1/2 the data .
Looking in the MDAC Books Online, I see that the fourth argument is a
size in bytes. Thus for Unicode, you say 2 *

RESOURCE_ID_LEN_PLUS_NULL. (Make sure that your buffer is also that size!)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp