unicode support (chinese)

"Van Shuka" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hello,

I'm working on CentOS 5.2
and connecting(sadly)  to MS SQL Server 2005 with unixODBC+FreeTDS 0.82

The data i need to insert/select is unicode chinese characters (like 0x4e2d)
into nvarchar(50) field.


SQLINTEGER chineseCharInd;
SQLWCHAR chineseChar[3]={0};

chineseChar[0] = 0x4e2d;
chineseChar[1] = 0x5152;
chineseChar[2] = 0;

However binding this parameter with:

sqlError = SQLBindParameter(sqlStmt, 1, SQL_PARAM_INPUT,
        SQL_C_WCHAR, SQL_WVARCHAR, 50, 0,
        &chineseChar, sizeof(chineseChar), &chineseCharInd);

I'm getting the error state=HY004, [FreeTDS][SQL Server]Invalid data type


And when I'm trying to select data using

sqlError =
SQLBindCol(sqlSelectStmt,1,SQL_C_WCHAR,sqlName,sizeof(sqlName),&ValNameInd);

I'm getting the error:
state=HY003 [FreeTDS][SQL Server]Program type out of range.

(The same code runs on XP correctly).

Is there anything I'm missing?
Appreciate your help.

Van
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.