shannon.patterson, Member
Hi,
I am running myDBR 3.9.4 with MSSQL and when I try to edit a report I get the following error:
DB error: 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.
SQL: sp_MyDBR_ReportInfoGet 4
This is happening for multiple reports - basically any time I try to edit anything.
It also happens for this SQL: sp_MyDBR_ReportNameGet 4,'dba',2,''
myDBR Team, Key Master
Hi,
if you are using FreeTDS make sure you are using TDS version 8.0. This is defined in the freetds.conf. Older TDS protocol versions (default in FreeTDS is 4.2) do not support Unicode.
--
myDBR Team
shannon.patterson, Member
we are not using FreeTDS.
myDBR Team, Key Master
The error message looks like a FreeTDS error.
What is the operating system for the server where your myDBR is installed and what is the PHP database library you are using?
--
myDBR Team
shannon.patterson, Member
it's a windows server and we're using mssql
myDBR Team, Key Master
Hi,
The mssql-extension is an old deprecated PHP extension and it is not supported. mssql extension does not support unicode (or many other features).
You have two options, use the FreeTDS version (just grab one from Moodle's site) or use Microsoft's PHP Driver if you are using PHP 5.4.
--
myDBR Team
You must log in to post.