#167 UNICODE error for MSSQL

MS SQL (15)

A user of the TYPO3 Adminer extension reported this:
This unicode Error is solved for DBAL/TYPO3 but appears still in adminer:

Warning: mssql_query() [function.mssql-query]:
message: 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. (severity 16) in C:\xxx\adminer-3.2.2.php on line 675

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xxx\adminer-3.2.2.php on line 675
MS SQL » x.x.x.x » xxx » dbo » Tabelle:

I will check with T. S. to deliver further information.
T. added:
As far as I know, this happens while using type TEXT for database fields. This can easily be fixed by using NVARCHAR in the field definition when using MSSQL.

If you need more information I'll try to connect you with the reporter.


  • Jakub Vrána

    Jakub Vrána - 2011-07-11
    • status: open --> pending
  • Jakub Vrána

    Jakub Vrána - 2011-07-11

    Maybe this is not a bug of Adminer at all. Adminer supports several MSSQL extensions. If a user uses extension without support for some feature (mssql) then Adminer couldn't do anything about it. Try enabling better extension in PHP (sqlsrv).


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks