My web application supports 3 languages, English, Traditional Chinese, Vietnamese. I understand that Traditional Chinese and Vietnamese is not supported in Postgres' Full Text Search.

If I were to go ahead and implement Full Text Search, what will happen if a text search is performed using an unsupported language?

  • Define "work". You've already confirmed it's unsupported. What are your expectations? FTS won't support word stemming for those languages, it'll treat them like unknown tokens. – Craig Ringer Oct 3 '14 at 4:28
  • Sorry about that, I've updated the question – wyred Oct 3 '14 at 4:30
  • OK... so what happened when you tried it? (Otherwise: Some sample data would be helpful, btw, maybe sqlfiddle.com) – Craig Ringer Oct 3 '14 at 4:43

There are Postgres extensions to handle Chinese. Have you tried http://pgxn.org/dist/zhparser/? You can then maybe port it to Vietnamese.

  • 1
    It would be better if you also answered the question. ("What will happen if ...?)" – ypercubeᵀᴹ May 21 '15 at 10:26
  • I see what you did there ;) – Rui Pacheco May 21 '15 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.