Menu
▾
▴
#291 MS SQL Error
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
Sorry, I don't have MS SQL. Feel free to send a patch.
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
Should be fixed by #237.