MSSQL数据库中文表名和中文字段无法查询
大佬们好,问个问题,我是用PHP里面加入数据库语句,但是表名和字段都是中文的,无法正常使用SQL语句,另外好像MYSQL和MSSQL的中文语句不大一样,在MYSQL里面加个单引号就可以查询了,在MSSQL不知道怎么写,谢谢~~~~
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<title>php中mssql数据库简单查询完整实例</title>
<meta charset="utf8">
<meta name="author" content="yanue" />
<meta name="copyright" content="powered by yanue" />
</head>
<body>
<?php
$serverName = "192.168.12.3";
$connInfo = array("Database"=>"ERP2", "UID"=>"fiber", "PWD"=>"fiber");
$conn = sqlsrv_connect($serverName, $connInfo);
if($conn){
echo "连接成功";
$query = "SELECT TOP 15 * FROM '主检长度'";
$result = sqlsrv_query($conn, $query);
//打印输出
while($row = sqlsrv_fetch_array($result))
{
$e = $row[“”棒号“”];
$e = iconv("GBK", "UTF-8//ignore", $e);//为了解决中文乱码问题
echo"<table border='1px' align='center'>";
echo"<tr>";
echo"<td>";
echo $e;
echo"</td>";
echo"</tr>";
echo"</table>";
//print_r("$e");
}
//echo phpinfo();
}else{
echo "连接失败!";
die( print_r(sqlsrv_errors(), true));
}
//-----------------------------
//-------------------------------
?>
</body>
</html>