Php mssql extension SQL query solution for Chinese field names

Php mssql extension SQL query solution for Chinese field names

// Encoding conversion function Function utf8togb ($ s ){ Return iconv ('utf-8', 'gbk // IGNORE ', $ s); // when the IGNORE parameter is a character that cannot be converted, IGNORE } // We recommend that you replace all Chinese fields with English aliases to facilitate encoding and conversion in the following operations. $ SQL = "SELECT [id], [column] as typeid, [subject] as title, [author] as author, convert (text, [body]) as body FROM [document table]; "; $ SQL = utf8togb ($ SQL ); ?>