Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC

[eluser]Unknown[/eluser]
I'm having this error while accessing data through MSSQL stored procedure:

Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

Here in my stored procedure i'm trying to return a XML to CI, but it is giving this error.
In all the other cases its working fine.

My server is actually a Windows server and i'm using ntwdblib.dll to connect with MSSQL.

When i tried to search the same issue i found that it is some Charset issue so i tried to change the charset of the CI in config file but it didn't helped me.
(http://www.theserverpages.com/php/manual....mssql.php)

Anybody on this forum ever faced this problem?

[eluser]Ashish Awasthi[/eluser]
Check your db and if you have any "ntext" type then change it to text type.