Home » Performance » FullText » Japanese characters full text search
Japanese characters full text search [message #2559] Thu, 31 January 2008 02:53
arthurica  is currently offline arthurica
Messages: 7
Registered: January 2008
Junior Member
I am having some problems searching using the MATCH function for japanese words...

Here is the situation.. As you might know japanese words are not separate with spaces.. Here are 2 words (a composite one and a simple one)

1. ストライプジャケット (strive jacket)
2. ジャケット (jacket)

When I search for the first word I can find it. When I search for the second word (using MATCH function ojn a full text field) it will not find records containing the first word. It does makes sense to me since the words are not separated by spaces however how can I make it work?

I would like to mention that in some cases this will work even if the words are not separate by spaces so I guess I might be missing something

Is there an alternate solution for this? Most of the sites from Japan seems to have a solution for this and this applies for other sites as well

Any suggestion is really appreciate
Previous Topic:How to write a UDF for MySQL fulltext tokenization?
Next Topic:Slow Full-Text Search when table grows constantly
Goto Forum:
  



Current Time: Thu Jul 3 19:51:27 EDT 2008

Total time taken to generate the page: 0.00453 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge