This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell 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


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
 
Don't get me started about those stupid light bulbs.
 
subject: Problem of Query Chinese words in MySQL using Java (Servlet java)