Not at all. For your documents to be indexed according to the language they
are written in you have to either use a machine set up in the locale you
want them indexed in or if you are storing the documents in columns of the
image or varbinary data type, store the documents in a format which is
language aware, i.e. Word, XML (using the XML:Lang tag), or HTML using the
MS.Locale language metatag and specifying the correct code page. If you are
storing XML documents with the XML:Lang tag in the XML data type columns the
xml documents will be indexed correctly.

For most languages this is not a problem  for indexing (for the most part,
although exceptions do exists). The Far Eastern languages (especially
Chinese) are problematic.

For instance for documents stored in English and Germans this won't be a
problem until I query. Querying on English might return hits to German
documents if the words occur with the same spellings in both languages (look
up false friends). For FreeText there will be false conjugates.

Now when you query and you want to query in a language other than the
default language you can use the Language predicate in the
Contains/FreeText/ContainsTable/FreeTextTable predicates. Note further that,
for the most part