ADS API for Unicode data

[Shockers]

I have a Japanese Unicode data file and I imported the text file into my SQL database table with Japanese collation.

My SQL script select the data into NVARCHAR data type. I passed these data type to unsigned short * in my C++ code. I am using ADS API.

In my C++ code, I extract the data with
memcpy(utfStr, srv_paramdata(srvproc, 2), srv_paramlen(srvproc, 2));

The data I'm getting doesn't match the original input.

I tried using WideCharToMultiByte() but with no success.

ANyone does this before??

Thanks for your help!

[MAK]

I believe this will be useful to you


http://www.bramc.ru/soft/xprocvc.html


Some message in this link would be useful
http://groups.yahoo.com/group/Databa...ry/message/117

Actually, after looking at it, nvarchar is a SQL Server datatype that
translates into SQL_WVARCHAR (-9) datatypes


http://www.c-sharpcorner.com/Code/2002/Oct/SpParams.asp