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

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

glopezzAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
>>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
 
Anthony PerkinsCommented:
>>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
 
glopezzAuthor Commented:
Thanks acperkins,

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

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.