如何使用MySql处理日语搜索查询？ [英] How to handle search query with Japanese language with MySql?

问题描述

我使用MySQL Server作为Web App JSP，并且在MySQL中使用LIKE查询时遇到问题。
当我使用LIKE查询和Katakana类型的日语时，某些时候的结果无法正确显示。

示例：

  SELECT r.report_id，r.user_id，u.user_name 
 FROM report r JOIN用户u ON u.user_id = r.user_id 
 WHERE r.report_comment LIKE CONCAT（'％'，'AC'，'％'））
  

查询，当我用英语键入' AC '字符时，尝试用Java执行此查询。结果是正确的（返回1行）。

但是，当我用片假名键入' AC '字符并尝试执行此查询与Java。没有行被发现。

如何正确处理搜索查询？

MySQL CJK faq 包含有关如何处理日文字符的各种提示。
段落确保问题不在于浏览器或其他应用程序，而是与MySQL 似乎能够解决您的问题。

I use MySQL Server for Web App JSP, and have a problem with LIKE query in MySQL. When i use LIKE query with Katakana type of Japanese language, sometime results don't display correctly.

Example:

SELECT  r.report_id, r.user_id, u.user_name
FROM report r JOIN user u ON u.user_id = r.user_id
WHERE r.report_comment LIKE CONCAT('%', 'AC', '%') )

In this query, when i type 'AC' character with English, and try to execute this query with Java. Results is correct(1 row returned).

But when i type 'AC' character with Katakana, and try to execute this query with Java. No rows are found.

How to handle search query correctly with all of case?

解决方案

The MySQL CJK faq contains various tips about how to deal with Japanese character. The paragraph Make sure that the problem is not with the browser or other application, rather than with MySQL seems to provide fix to your issue.

这篇关于如何使用MySql处理日语搜索查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！