How to handle search query with Japanese language with MySql?
LazyCatIT
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?
ortis
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.
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
编辑于
相关文章
Related 相关文章
- 1
Search query optimization in mysql
- 2
How to search in the mysql command history
- 3
How to write contains query in SQLite fts3 fulltext search
- 4
Hibernate Search query for class
- 5
MySQL and PYTHON. How to query an WHERE 'column' IN tuple
- 6
将？search = query重写为/ search / query和分页
- 7
Elastic Search Query with Java Api
- 8
How to handle callback registration
- 9
How to handle encrypted string?
- 10
Addition from MySQL query
- 11
MySQL Query ORDER BY with modulus
- 12
MySQL Query with count, group by
- 13
Sorting a MySQL search result with Priority
- 14
Hibernate Search / Lucene - Search for and rank unrelated entities with a single query
- 15
Matlab - How to check the existence of a handle
- 16
How to make keypress handle Enter
- 17
Why search query not showing any result in PHRETS?
- 18
ElasticSearch Query Search with Highlight C# Nest
- 19
PHP中的多个$ query = mysql_query
- 20
从 mysql _query 转换为 mysqli_query
- 21
how to search for gist by name
- 22
How to insert multiple rows from a table to another table based on date condition (PHP-MySQL-Query)?
- 23
How to edit this mySQL query so as to find people who visited specific page more than x times?
- 24
MySQL NOT IN Query much slower after Mysql Upgrade
- 25
MySQL index usage query optimization
- 26
mysql spring data error（QUERY）
- 27
mysql: write query with if in where part
- 28
MYSQL query minus operator not working
- 29
MYSQL QUERY //发出COUNT个
我来说两句