The moose likes JDBC and the fly likes insert chinese language to mysql db Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "insert chinese language to mysql db" Watch "insert chinese language to mysql db" New topic

insert chinese language to mysql db

Li Jenny
Ranch Hand

Joined: Apr 19, 2010
Posts: 57
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
Ranch Hand

Joined: Jan 13, 2010
Posts: 70
You should use UTF-8 character encoding like this.

create database yourdb CHARACTER SET utf8 COLLATE utf8_bin;
subject: insert chinese language to mysql db
Similar Threads
JSP: Unable to connect to mysql in local drive [Solved]
Hibernate and Unicode
Can't write arabic text into mysql database using mysql prompt
how to convert mysql tables to utf-8 ?
insert chinese character jsp/java servlet