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:
-
Use dblib, and encode/decode all strings manually to/from the db to enable UTF8 strings to be captured?
-
Use ODBC, but write sql for every commumnication with the DB, rather than use activerecord?
Thanks in advance for your help!