PHP's MSSQL Extension SQL query solution for text segment names

Encoding Conversion functions function Utf8togb ($s) { Return Iconv (' Utf-8 ', ' gbk//ignore ', $s); The IGNORE parameter is ignored when a character that is not converted is encountered } It is recommended to replace all Chinese characters with English aliases, so as to facilitate the following operation and encoding conversion. $sql = "SELECT [ID], [column] as typeID, [subject] as title, [author] as author, convert (text, [body]) as body from [Article table];"; $sql = UTF8TOGB ($sql); ?> Copy Code

