0

I can see no obvious of way of achieving this but I have a database with a text field - it contains text in various languages, for example:

  • English
  • US English
  • Japanese
  • Arabic
  • German

Is there a way within MySQL to determine the language of the text in the field?

Homer_J
  • 3,277
  • 12
  • 45
  • 65
  • no. consider `gift`: English: present. German: poison. – Marc B Jul 16 '15 at 15:40
  • I really don't think that such feature exists. You should retrieve the field from the database and THEN process the string using some logic used to detect the language. – Ema.jar Jul 16 '15 at 15:47
  • 1
    Not directly from MySQL - see this though : http://stackoverflow.com/questions/1192768/how-to-detect-the-language-of-a-string – PaulF Jul 16 '15 at 15:49
  • Thanks @PaulF, really appreciated. Not sure how I didn't spot that in my search of SO before posting. – Homer_J Jul 16 '15 at 16:00

0 Answers0