長島冰茶的工程師筆記

************************
* MS SQL or Sybase 整合
************************
#yum -y install freetds
#yum -y install php-mssql

# vim /etc/freetds.conf
[global]
...
charset = big5

# FOR MSSQL
[TDS]
        host = 192.192.105.66
        port = 2866
        tds version = 8.0

# FOR SYBASE
[STDS]
        host = 192.192.105.66
        port = 1433
        tds version = 4.2

#tsql -S TDS -U sa
1> use mydatabase
2> select * from mytable
3> go 


** 如果登入有問題連線有問題, 修改 /etc/sysconfig/i18n
LANG="zh_TW.UTF-8"

** 如果執行 PHP  發生以下錯誤
Warning: mssql_query(): WARNING! Some character(s) could not be converted into client's character set.
Unconverted bytes were changed to question marks ('?')

請在 TDS sector 加上 client charset =UTF-8
[TDS]
 host = 192.192.105.66
 port = 1433
 tds version = 8.0
 client charset =UTF-8



 


mssql_connect('MSsql','LoginName','Password');
mssql_select_db("DB_Name");
$rs = mssql_query("select * from Table_Name");
$rs_data = mssql_fetch_row($rs);
echo $rs_data[0];

8.以ADODB進行PHP取得料測試

$MSconn = NewADOConnection('mssql');
$MSconn->PConnect("MSsql", "DB_Name", "LoginName", "Password");
$rs = $MSconn->Execute("select * from Table_Name");
echo $rs->fields(0);

[經驗分享]
web-php程式撈出資料時中文出現???的解決方式:
更改php.ini中
;mssql.charset = "ISO-8859-1"
變更為
mssql.charset = "cp950"
之後apache重啟即可正常顯示