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 )