Unable to retrieve VARCHAR data in wchar_t buffer

[Intrepid Soldier]

Hello all,
My database has a single table with a single column of the type
VARCHAR(20). I insert one record into this table through the command
line and then I try to retrieve this record through ODBC API.

I bind a wchar_t structure to this column with the type as SQL_C_WCHAR
using SQLBindCol. But when SQLFetchScroll returns, the buffer is still
empty.

I am trying this on Redhat Linux 9.0 with unixODBC-2.2.3-6,
MyODBC-3.51.09 and MySQL-server-4.0.21-0.

The exact same code works fine on Windows.

Could someone tell me what could be going wrong.

Thanks,
Raman

[Intrepid Soldier]

Could someone please find some time to share your experience ( if any
) about this problem.

Thanks,
Raman
in*************@gmail.com (Intrepid Soldier) wrote in message news:<8b*************************@posting.google.c om>...

Hello all,
My database has a single table with a single column of the type
VARCHAR(20). I insert one record into this table through the command
line and then I try to retrieve this record through ODBC API.

I bind a wchar_t structure to this column with the type as SQL_C_WCHAR
using SQLBindCol. But when SQLFetchScroll returns, the buffer is still
empty.

I am trying this on Redhat Linux 9.0 with unixODBC-2.2.3-6,
MyODBC-3.51.09 and MySQL-server-4.0.21-0.

The exact same code works fine on Windows.

Could someone tell me what could be going wrong.

Thanks,
Raman

[Carmen Alvarez]

Did you find the solution to this problem?

Could someone please find some time to share your experience ( if any
) about this problem.

Thanks,
Raman


[e-mail] (Intrepid Soldier) wrote in message news:<[e-mail].c om>...[color=blue]
> Hello all,
> My database has a single table with a single column of the type
> VARCHAR(20). I insert one record into this table through the command
> line and then I try to retrieve this record through ODBC API.
>
> I bind a wchar_t structure to this column with the type as SQL_C_WCHAR
> using SQLBindCol. But when SQLFetchScroll returns, the buffer is still
> empty.
>
> I am trying this on Redhat Linux 9.0 with unixODBC-2.2.3-6,
> MyODBC-3.51.09 and MySQL-server-4.0.21-0.
>
> The exact same code works fine on Windows.
>
> Could someone tell me what could be going wrong.
>
> Thanks,
> Raman[/color]