By default, full text search in English requires a minimum of three characters and requires a
* to find subterms, (e.g. “real” doesn’t find “realtime” but “real*” does find "realtime).
This doesn’t work well for Japanese, Korean, Chinese or other idiographic languages.
Because this behavior is defined in the full text search capabilities of the underlying database (MySQL or Postgres), we’re hoping someone familiar with Japanese would be able to test to see if certain configurations of the database could be used to optimize for searching Japanese:
For example, could are there full text search parameters for using Japanese in Postgres that would change the default behavior so that
* wouldn’t be needed to match characters, and by default search would support single characters–unlike the default English settings.
Would anyone be open to helping test and share advice for other international users?