Force OpenX using UTF-8 charset

OpenX (aka Openads, PhpAdsNew) 在支援 UTF-8 不是很完整,須要手動指定編碼,才可以在使資料庫存取時使用正確的編碼。每次升級前也需記得先更正編碼的部份,否則更新程序會使用錯誤的編碼重新編了一資料,結果又會是一堆亂碼.

This is for mySQL only, and remember do the same changes before upgrade

file: openx/lib/OA/DB.php
search: $oDbh->setFetchMode(MDB2_FETCHMODE_ASSOC);
add after: $oDbh->query("SET NAMES utf8");

file: openx/lib/OA/Dal/Delivery/mysql.php
search: if (@mysql_select_db($dbName, $dbLink)) {
add before: @mysql_query("SET NAMES utf8");


Comments (4)

Login

E-mail
Password

Login with Facebook

App Store

zhim! extended
支援行列、倉頡、嘸蝦米、大易、倚天、拼音、注音中文輸入法等,眾多輸入法的記事本。

iLyrics Mobile
中、英、日歌詞的行動搜尋利器。

Google+

Google Ads

About the Author

I'm a freelance developer. Live as web developer, UI designer, iOS developer, webmaster, consulter and "fireman" for many projects.

Tweets from Ethan Liu

趁過年時候開始 iLyticsWidget3 差不多完工了
13 hours ago (RT, @)

@SwampyTheGator I Tri-Ducked "Meet Swampy" #wheresmywater http://t.co/urovJ5xi
Dec 25, 2011 (RT, @)

隔壁先是燒焦,再來是煎魚,滿屋子魚皮味讓我一直反胃…你們可以不要天天煎魚嗎!!!!!!!
Dec 20, 2011 (RT, @)

第一次買高鐵電子車票,然後我就買錯日期了,可惜換票不能換一張數位的給我
Dec 10, 2011 (RT, @)

I like the new look of youtube
Dec 3, 2011 (RT, @)

is javascript:alert() disable by windows7?
Nov 28, 2011 (RT, @)

no more web app for app store please, bookmarks for safari is your home
Nov 22, 2011 (RT, @)

@chocolatapp thank you
Nov 22, 2011 (RT, @)

no column selection? lots of textmate's power are missing @chocolatapp
Nov 21, 2011 (RT, @)

“@CloudFlareSys: attack in ams mitigated. will continue to monitor.” looks like still surffering
Nov 17, 2011 (RT, @)

Thank You Steve

Do NOT follow this link or you will be banned from the site!