MySQL 5.1.x & unicode

In our recent upgrade from 5.0 to 5.1.47, the new version behaves differently and it screw up character set when user submit info from our web app powered by .NET.

After digging around for a afternoon, this is how to fix it:

vi /etc/my.cnf


And add those lines to the config:

init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake


There are other options for collation besides utf8_general_ci such as utf8_unicode_ci. See this article:
http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html

Reference: http://rhyous.com/2009/11/05/how-to-create-a-utf-8-unicode-database-on-mysql/

RHEL: Install GNOME from console

this will do:
yum groupinstall "X Window System" "GNOME Desktop Environment"


To start the desktop, just type startx

CentOS: Install git

1. Download and install EPEL if you don't have it yet:
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm


2. Install git via yum
yum --enablerepo=epel install git

XShell profile/session backup

XShell from NetSarang is a great SSH client that we use. Even one awhile, you might wanna back up all the saved profiles.

The profiles are actually located at: %user_profile%\%username%\AppData\Roaming\NetSarang\Xshell. For example, C:\Users\johnny\AppData\Roaming\NetSarang\Xshell.

You can just copy the directory to where you want to back it up. You can also create sub-directories if you want to manage them a bit.

開發網路電視 Panasonic不採用Android系統

Bloomberg報導，日本電子大廠 Panasonic (6752-JP) 高層表示，由於成本過高，公司生產的網路電視決定不採用 Google (GOOG-US) Android 作業系統。

積極推廣 Android 作為網路電視平台的 Google，嘗試與 Panasonic 合作卻遇挫。

Panasonic Consumer Electronics Co. 資深副總派瑞 (Robert Perry) 說，Android 雖是免費，卻需要價格不斐的技術來支援，包括英特爾的高價晶片。

Panasonic Consumer Electronics 是 Panasonic 的美國子公司。

派瑞周二出席舊金山召開 3D 技術發表會，他會後表示，Android 平台「須利用晶片的處理能力，將增加成本負擔」。

將網路導入家庭娛樂產品漸成趨勢，Panasonic、三星電子 (005930-KR)、索尼 (6758-JP) 等電視製造商今年均計畫推出相關產品。

根據日前報導，Google 與英特爾正攜手開發「Google TV」平台，讓用戶可透過電視來上網。消息人士透露，索尼也參與了該平台開發計劃。

全球第4大電視製造廠的 Panasonic，則選擇自行研發網路軟體，透過自家的伺服器傳送網路內容。

Mastering the VI editor

Good basic - http://www.eng.hawaii.edu/Tutor/vi.html
Download PDF version here

iPhone: Internet Tethering option is gone!?

If it happens to you, on the phone, navigate to help.BenM.at, follow the instruction to reinstall carrier profile.

This works 3G, 3GS, OS version 3.1 or up, no need to jail-break.