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
Log in to post a comment.