Solved

Multi-Language support for full-text searching in SQL Server 2000

Posted on 2004-09-01
5
237 Views
Last Modified: 2008-02-07
Hi,
I'm building an application which will store multi-language string values in my database.

I am also building a search engine based on SQL Server 2k's full-text search capabilities. I understand that full-text search results depend a lot on the language and context of the phrases.

Question is: Do I need to create a different table or DB for each language and set the default language of each DB individually, or can SQL server full-text searching support multi-language queries into a single table or DB?

Thanks!

Jerry

0
Comment
Question by:glopezz
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 11955146
>>Do I need to create a different table or DB for each language and set the default language of each DB individually, or can SQL server full-text searching support multi-language queries into a single table or DB?<<
No you do not need to create a different table or DB, you can define the Full-Text Search language per column.
0
 

Author Comment

by:glopezz
ID: 11955193
Thanks acperkins,

Could you be a little more specific on how to define this? Can a single column support different languates?

Thanks
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 125 total points
ID: 11957525
>>Could you be a little more specific on how to define this?<<
Define a Full-Text search and it will be self-evident.  Alternatively readup on this subject in BOL.

>>Can a single column support different languates?<<
No.  You can only define one language per column.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question