Change the following in my.cnf [mysqld] default-character-set= utf8 skip-character-set-client-handshake character-set-server= utf8 collation-server= utf8_general_ci init-connect= ‘SET NAMES utf8′ via M’sNOTE MySQL(デフォルト文字コード)の設定 – Ubuntu9.04.
The website is up, and running on a brand new OS – Ubuntu 9.04 Server. Supercool to configure, has pre-configured LAMP, OpenSSH out-of-the-box. Using the… Read More »Server upgraded to new Ubuntu 9.04 server
A very informative page (in Japanese) about MySQL and issues to enable correct UTF-8 data handling with client applications. View original post
MySQL has a killer feature – you can have a timestamp field with DEFAULT as LOCALTIMESTAMP, so that when you insert a new record, the… Read More »MySQL’s killer feature