Day: February 24, 2009
codeigniter / ci / oracle database.php 的設定方式 / utf8 / big5 粉難搞
$db['oci']['hostname'] = "//IP_ADDRESS/INSTANT_NAME"; $db['oci']['username'] = "USERNAME"; $db['oci']['password'] = "PASSWORD"; $db['oci']['database'] = "INSTANT_NAME"; $db['oci']['dbdriver'] = "oci8"; $db['oci']['dbprefix'] = ""; $db['oci']['pconnect'] = TRUE; $db['oci']['db_debug'] = TRUE; $db['oci']['cache_on'] = FALSE; $db['oci']['cachedir'] = ""; $db['oci']['char_set'] = "utf8"; // database 是 UTF8 $db['oci']['char_set'] = "ZHT16BIG5"; // database 是 big5 $db['oci']['dbcollat'] = "utf8_general_ci";
記得 codeigniter 的 /system/database/drivers/oci8/oci8_driver.php 這個檔要改一下
2009.0303 補充, 若要連 oracle standby database.php 要改成這樣 用 service name ( 看那個 tnsnames.ora )
宜蘭國道五號馬拉松
這樣量距離只有不到 30K?
[note] javascript 的 foreach / split / php explode style 寫法
var loc="25.258861, 121.509389";
var arr=loc.split(",");
var content = '';
for (var key in arr) {
content += key + ' : ' + arr[key] + "\n";
}
另一個
var myarr = new Array('red','green','blue');
var content='';
for(var key in myarr){
content += key+' : '+myarr[key]+"\n";
}
alert( content );