This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem of Query Chinese words in MySQL using Java (Servlet java)
 
Similar Threads
Need help in java array
mysql 's chinese font
Chinese processing problem in JSP
hi,everybody
insert chinese character jsp/java servlet