insert chinese language to mysql db

[Li Jenny]

i would like to ask how can i insert chinese character into db
as i type chinese in the textarea,then insert.
i view in db is become symbol (not eng and chinese)

need to set characterset in mysql and also set the characterset in jsp??

[Ravinderjit Singh]

You should use UTF-8 character encoding like this.

create database yourdb CHARACTER SET utf8 COLLATE utf8_bin;