#291 MS SQL Error

open
nobody
MS SQL (15)
5
20 hours ago
2013-01-03
Jean-Guy BUON
No

Hello,

I just uploaded adminer to try it because I'm actually migrating my web application from MySQL to MS SQL.

I was using php MyAdmin and would like a similar interface to manage my databases on MS SQL.

Adminer seems to be the perfect tool for my need!

So I tried it on MySQL it's working well.

Now, I tried to use it on MS SQL and even if I can see existing databases & tables, I can't access to table content as I have the following error:
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 L:\Programs\wamp\www\Adminer\adminer.php on line 613

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.

I send you in atachment a screenshot with MS SQL table definition.

Could you give me a hand?

The SQL Server version is: Microsoft SQL Server 2012 - 11.0.3000.0 [SP1] Standard Edition (64-bit) via l'extension PHP MSSQL

Many thanks,

Jean-Guy

Discussion

  • Jean-Guy BUON
    Jean-Guy BUON
    2013-01-03

     
    Attachments
  • Jakub Vrána
    Jakub Vrána
    2013-01-10

    Sorry, I don't have MS SQL. Feel free to send a patch.

     
  • Jakub Vrána
    Jakub Vrána
    2013-01-10

    • assigned_to: jakubvrana --> nobody
     
  • KEFE
    KEFE
    2014-03-20

    Just a bit of help:
    The issue is not with adminer, you're using nvarchar data types, which is OK for the server it self, MSSQL Engine 11, however you're running an old PHP MSSQL extension, which cannot handle unicode data... There are two solutions you either change the nvarchar data types to varchar (also if you would use ntext use text) OR you install a newer more up-to-date PHP extension, see here: http://www.microsoft.com/en-us/download/details.aspx?id=20098