#167 UNICODE error for MSSQL

3.2.2
pending
MS SQL (15)
5
2011-07-11
2011-07-07
No

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.

Discussion

  • 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