若資料庫是 Big5, web page 卻已經寫成 UTF8 code... 如果只有一兩欄有中文字 可以在SQL command中直接這樣用: CONVERT(fields USING big5) 如果資料欄位多 可以用這小 function 去做線上 Big5->UTF8 轉換mysql_query("SET NAMEs 'big5'"); big52utf8($row['fields']) function big52utf8($big5str) {
2011/03/23
PHP on-line Big5->UTF8 convert function
2011/03/18
VB6 使用 MySQL
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "DRIVER=MySQL ODBC 3.51 DRIVER;SERVER=" & IP & ";DATABASE=" & DB_Name & ";USER=" & UserName & ";password=" & Passwd & ";OPTION=3;"
rs.ActiveConnection = cn
rs.Source = "SELECT * FROM Table_X;"
rs.Open
Do While (Not rs.EOF)
.....
rs.MoveNext
Loop
rs.Close
cn.Close
Set rs = New ADODB.Recordset
cn.Open "DRIVER=MySQL ODBC 3.51 DRIVER;SERVER=" & IP & ";DATABASE=" & DB_Name & ";USER=" & UserName & ";password=" & Passwd & ";OPTION=3;"
rs.ActiveConnection = cn
rs.Source = "SELECT * FROM Table_X;"
rs.Open
Do While (Not rs.EOF)
.....
rs.MoveNext
Loop
rs.Close
cn.Close
訂閱:
文章 (Atom)