wood burning stoves 2.0*
The moose likes Servlets and the fly likes Problem of Query Chinese words in MySQL using Java (Servlet java) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Problem of Query Chinese words in MySQL using Java (Servlet java) " Watch "Problem of Query Chinese words in MySQL using Java (Servlet java) " New topic
Author

Problem of Query Chinese words in MySQL using Java (Servlet java)

Ken Shamrock
Ranch Hand

Joined: Jan 23, 2002
Posts: 139
In my servlet, if I build in this sql inside ,
SELECT * FROM table WHERE location='Chinese word here'
It outputs nothing!
if i change the 'Chinese word here' to English,it have result!
But if I query in mysql, i can
If the 'Chinese word here' is get in a form, (ie 'Chinese word here' is got by req.getParameter but not built in), it can display result, why???


Thanks everyone who helped me
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem of Query Chinese words in MySQL using Java (Servlet java)