Linux使用php連接MSSQL+UTF-8

2018 年 11 月 11 日

先安裝套件Freetds、 ODBC

yum install unixODBC
yum install freetds

然後進入freetds的設定檔

vi /etc/freetds.conf

加入下面兩行

tds version = 7.2
client charset = UTF-8

 

tds version
可以參照

https://www.freetds.org/userguide/choosingtdsprotocol.htm

 

設定完之後最好重開機

 

php測試

<?php  

try {

    //connection params
    $dbCon = new PDO('odbc:Driver=FreeTDS; Server=my_server_host; Port=1433; Database=database(資料庫名稱); ClientCharset=UTF-8', 'login(帳號)', 'pass(密碼)');

    //test query
    $result = $dbCon->query('SELECT TOP 10 * FROM dbo.table1');

    //show the results
    foreach ($result as $row)
    {
        print_r( $row );
    }

    //close the connection
    $dbCon = null;

} catch (PDOException $e) {

    //show exception
    echo $e->getMessage();

}
?>