File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

insert chinese language to mysql db

 
Li Jenny
Ranch Hand
Posts: 57
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 78
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should use UTF-8 character encoding like this.

create database yourdb CHARACTER SET utf8 COLLATE utf8_bin;
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic