[Plugin: External DB authentication] “SET NAMES ‘utf8′” causes SQL Server to die

Hi outspaced,

Do you know what the SQL server equivalent query may be for setting UTF-8? It does affect import of fields, and I’d prefer this to work across all setups.

Or do you know if unicode fields were already importing correctly with SQL Server?

I had the same problem, I do not believe anything special needs to be done on MSSQL to support unicode. However, I have not tested it

I got the same problem today.

This problem was reported two month ago, but the same problem is still happening. Interesting.

Please make the code working only for MySQL if you are not sure about the compatibility.

from

$utfquery = “SET NAMES ‘utf8′”;
$resultutf = db_functions($driver,”query”,$resource,$utfquery);

to

if ($driver == “MySQL”)
{
$utfquery = “SET NAMES ‘utf8′”;
$resultutf = db_functions($driver,”query”,$resource,$utfquery);
}

After 8 month, same bug with MS SQL Server. Thanks Snooki for fix.

Don’t forgot that for next update please ??

if ($driver == "MySQL")
{
$utfquery = "SET NAMES 'utf8'";
$resultutf = db_functions($driver,"query",$resource,$utfquery);
}

Thank you !!