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

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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

    soonki-ji

    (@soonki-ji)

    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 !!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: External DB authentication] “SET NAMES ‘utf8′” causes SQL Server to die’ is closed to new replies.