I’ve set up a Yii2 REST framework with a connection to our MSSQL server via the dblib driver.

All appeared to be working ok, until we found some issues with sending UTF8 strings to the DB.

I understand that dblib does not fully support UTF8 with MSSQL?

From research, i’ve been told to look at the Microsoft ODBC driver, however when using it i get the following error:

“Connection does not support reading schema information for ‘odbc’ DBMS.”

Does this mean my choices are either:

  1. Use dblib, and encode/decode all strings manually to/from the db to enable UTF8 strings to be captured?

  2. Use ODBC, but write sql for every commumnication with the DB, rather than use activerecord?

Thanks in advance for your help!