Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2005

Tip: Looking for answers? Try searching our database.

FTS for particular language

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leila - 17 Jul 2005 20:49 GMT
Hi,
I need an article to learn customization of FTS for other languages.
Thanks in advance,
Leila
Hilary Cotter - 18 Jul 2005 00:26 GMT
Are you looking for an Arabic word breaker? Your header seems to indicate
you are from the Middle East. If so have a look at this -

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sq
l_arabicsupport.asp

(this covers how to configure SQL FTS for Arabic - but uses the neutral word
breaker).

or this

http://www.microsoft.com/middleeast/arabicdev/beta/search/

Which is the Arabic word breaker.

If you simply want to search in another language all you do is configure
your column for the language of your choice (sp_fulltext_column) like this

exec sp_fulltext_column 'TableName', 'ColumnName', 'add', 1033

You might want to review this which talks about how to use the Wizard for
this:

http://www.indexserverfaq.com/SQLFTIWizard.htm

If you are looking at using at developing a  new word breaker you might want
to review this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/w
brscenario_4ckl.asp?frame=true


If you are looking for some of the new language resources options in SQL
2005 you might want to check this out.

http://www.pinpub.com/ME2/Audiences/dirmod.asp?sid=&nm=&type=Publishing&mod=Publ
ications%3A%3AArticle&mid=8F3A7027421841978F18BE895F87F791&AudID=3A23D70D325A41A
9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E


Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
> I need an article to learn customization of FTS for other languages.
> Thanks in advance,
> Leila
Leila - 18 Jul 2005 06:55 GMT
Thanks for the great links!
Yes, arabic is the language which I'd like to enhance FTS for.

> Are you looking for an Arabic word breaker? Your header seems to indicate
> you are from the Middle East. If so have a look at this -

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_arabicsupport.asp
> (this covers how to configure SQL FTS for Arabic - but uses the neutral word
> breaker).
[quoted text clipped - 17 lines]
> If you are looking at using at developing a  new word breaker you might want
> to review this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/ht
ml/wbrscenario_4ckl.asp?frame=true

> If you are looking for some of the new language resources options in SQL
> 2005 you might want to check this out.

http://www.pinpub.com/ME2/Audiences/dirmod.asp?sid=&nm=&type=Publishing&mod=
Publications%3A%3AArticle&mid=8F3A7027421841978F18BE895F87F791&AudID=3A23D70
D325A41A9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E

> --
> Hilary Cotter
[quoted text clipped - 8 lines]
> > Thanks in advance,
> > Leila
John Kane - 18 Jul 2005 03:49 GMT
Leila,
What language are you looking to learn about customizing FT Indexing and FT
Search? Could you post the full output of the below SQL code, as this will
provide info on your current environment and perhaps the language you are
interested in is already supported.

use <your_database_name_here>
go
SELECT @@language
SELECT @@version
-- an advance option for sp_configure...
sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

I have worked in the past with someone from Greece, who implemented a custom
wordbreaker and stemmer for the Greek language (a non-trivial effort), and
helped him incorporate the Greek language (a non-supported SQL Server 2000
FTS language). What language do you want to add to SQL Server 2000 FT
Indexing & Search? Have you already developed your own language-specific
word breaker and stemmer?

Thanks,
John
Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hi,
> I need an article to learn customization of FTS for other languages.
> Thanks in advance,
> Leila
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.