改 oracle 的內碼成 utf8 commands

select * from v$nls_parameters 1 NLS_LANGUAGE TRADITIONAL CHINESE 2 NLS_TERRITORY TAIWAN 3 NLS_CURRENCY NT$ 4 NLS_ISO_CURRENCY TAIWAN 5 NLS_NUMERIC_CHARACTERS ., 6 NLS_CALENDAR GREGORIAN 7 NLS_DATE_FORMAT DD-MON-RR 8 NLS_DATE_LANGUAGE TRADITIONAL CHINESE 9 NLS_CHARACTERSET WE8ISO8859P1 10 NLS_SORT BINARY 11 NLS_TIME_FORMAT HH.MI.SSXFF AM 12 NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 13 NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 14 NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM … Read more

Codeigniter 聯接 Oracle database 要改的地方

Codeigniter version 1.6.3 Oracle version 10.2.0.4 use oci8 遇到這個 error : Message: ocifetchinto() expects parameter 1 to be resource, null given // 這個檔 \system\database\DB_driver.php 改成.. // $RES->num_rows = $RES->num_rows(); if ($this->dbdriver == ‘oci8’) { $RES->stmt_id = $this->stmt_id; $RES->curs_id = NULL; $RES->limit_used = $this->limit_used; } $RES->num_rows = $RES->num_rows(); 解決沒有使用 UTF8 的問題 // 這個檔 \system\database\drivers\oci8\oci8_driver.php // 改兩個地方: … Read more

Install Oracle 10.2.0.4 using vmware image

image 從這邊抓的 http://thepiratebay.org/torrent/4206241/ 裝好後的啟動 command: Listener: $ lsnrctl start Database: $ sqlplus /nolog SQL> conn / as sysdba SQL> startup; DB Console: $ emctl start dbconsole then open browser and go to https://localhost:5500/em You can login as sys/oracle using the SYSDBA role. sqlplus /nolog SQL*Plus: Release 10.2.0.3.0 – Production on Wed Oct 1 18:50:04 2008 … Read more

install oracle instant client basic on gentoo linux step by step

emerge -av dev-db/oracle-instantclient-basic dev-db/oracle-instantclient-sqlplus — !!! dev-db/oracle-instantclient-basic-11.1.0.7.0 has fetch restriction turned on. !!! This probably means that this ebuild’s files must be downloaded !!! manually. See the comments in the ebuild for more information. * Please go to: * http://www.oracle.com/technology/tech/oci/instantclient/index.html * select your platform and download the * Basic client package with SDK, which are: … Read more

周杰倫 不能說的秘密 MV

1. [youtube]http://tw.youtube.com/watch?v=C6dO6hCunTA[/youtube] 這對戰太精彩了^_^ [youtube]http://tw.youtube.com/watch?v=8XLO2IaOwZk[/youtube] 3 ……. [youtube]http://tw.youtube.com/watch?v=drNfZ0t4fK0[/youtube] 4. [youtube]http://tw.youtube.com/watch?v=pIiKmpw3IS8[/youtube] 5.不能說的秘密 – 路小雨 MV(piano) [youtube]http://tw.youtube.com/watch?v=5F3O1FBLNHM[/youtube]

最簡單的最好 – 用 pre 的 CSS style

CSS 是這樣的 pre { background: #F0F0F0 url(images/blogger-code.gif) repeat-y scroll left top; border: 1px solid #CCCCCC; color: #333333; display: block; font-family: Courier New; font-size: 8pt; line-height: 120%; margin: 5px 0 0 20px; max-height: 200px; overflow: auto; padding: 10px 10px 10px 21px; width: 90%; } 完全不用 javascript , 直接寫到 wordpress 的 style.css 裡 , 要用時就直接用 html pre … Read more

裝了一個 video plugins for wordpress – Viper’s Video Quicktags

http://wordpress.org/extend/plugins/vipers-video-quicktags/ 這些不錯聽 [youtube]http://tw.youtube.com/watch?v=FRH6K-COpNE[/youtube] [youtube]http://tw.youtube.com/watch?v=4SY_jVI4cxg[/youtube] 這有介紹那歌跟那個帥哥 – 青山黛瑪-留在我身邊 + SoulJa-在妳身邊(音樂+MV+歌詞+羅馬拼音) http://ruoyou.pixnet.net/blog/post/18980869 ★日本樂壇巨匠細野晴臣、高橋幸宏等大師跨刀背書,新生代最具實力潛力新人SoulJa ★遠距離戀愛飆淚單曲「在妳身邊」,霸佔公信榜單曲榜TOP 10長達一個月 SoulJa / Spirits 028230-9 0440-02823090 label: universal music 出版年月: 2007.11