Just added a new trade section, dedicated to the sharing of my trading experience and stock selection.
I've decided to write in chinese, so have spent some time to enable chinese character support. Actually it's just 3 simple steps.
Read on for instructions on displaying chinese character for a site powered by Java, Tomcat and Mysql.
In Context.xml, edit Data Source
If you want chinese charater in URL, like http://www.derekdan.com/trade?tag=手套股, edit the following in Server.xml
<Connector port="80" ... URIEncoding="UTF-8"/>
<%@page pageEncoding="UTF-8" contentType="text/html; charset=UTF-8"%>
Excecute ALTER TABLE for every column that contains chinese character
ALTER TABLE <TABLE_NAME> MODIFY COLUMN <COLUMN_NAME> VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci
Beware that NOT all data type support character set, e.g. BLOB stores data in byte format, so you can't assign any CHARACTER SET to it.
For this reason, previous I was using BLOB type to store my article content, now have to change to TEXT.