Solved

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

Posted on 2004-09-01
5
245 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

717 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