Two languages for full text search.

• robert.jammernegg

  Valued Member

  Points: 72

  More actions

  September 3, 2013 at 3:30 am

  #276758

  Hi,

  we have a column in a table in wich data is stored in a varbinary(max) field.

  The data is stored in different laguages. Is it possible to use the full text search

  with two languages?

  Your help would be appreciated,

  thanks a lot.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  September 3, 2013 at 8:48 am

  #1647064

  Yes, but you need a union query. Each FTS query is single language. Use two with the LCID for each, joined by a UNION.

• robert.jammernegg

  Valued Member

  Points: 72

  More actions

  September 4, 2013 at 1:54 am

  #1647203

  Hi Steve,

  Thanks for your advice, your information was very helpfull.

  Kind Regards

  Robert.