Chinese characters in SELECT query
-
Hi friends, I am working with SQLServer 2005 database (Collation set as Chinese) using odbc api SQLExecDirect and SQLExecute. Some of my SELECT queries containing some chinese characters works fine with SQLExecute and SQLExecDirectW but NOT with SQLExecDirect. My gut feeling is SQLExecute is converting the query into unicode before it executes. Is this assumption right ? thank you
cheers Varghese Paul
-
Hi friends, I am working with SQLServer 2005 database (Collation set as Chinese) using odbc api SQLExecDirect and SQLExecute. Some of my SELECT queries containing some chinese characters works fine with SQLExecute and SQLExecDirectW but NOT with SQLExecDirect. My gut feeling is SQLExecute is converting the query into unicode before it executes. Is this assumption right ? thank you
cheers Varghese Paul
This would depend on the driver and it's implementation. One problem you may encounter is: http://support.microsoft.com/kb/271198[^]. However, if SQLExecDirectW is working, why not use it instead of SQLExecDirect.
The need to optimize rises from a bad design.My articles[^]