Friday, February 24, 2012

Full-text search for a new language (MSSQL Server 2005)

Hi gurus.
I want to implement a full-text search support for texts of my native
language in MS SQL Server 2005.
But my language (Ukrainian) is not supported. So i would like to implement a
module for this language by myself.
Unfortunately i've failed to find what API i have to implement. Can anybody
help me?
--
Tkx.Hi
Ask this in the SQL Server 2005 newsgroups:
http://communities.microsoft.com/ne...p=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ihor Orobchuk" wrote:

> Hi gurus.
> I want to implement a full-text search support for texts of my native
> language in MS SQL Server 2005.
> But my language (Ukrainian) is not supported. So i would like to implement
a
> module for this language by myself.
> Unfortunately i've failed to find what API i have to implement. Can anybod
y
> help me?
> --
> Tkx.
>
>|||Will Russian work for you? I realize they aren't the same language but they
have a common root and a lot of the language rules are the same (from what I
understand).
Other than that check out
http://msdn.microsoft.com/library/d...
efint_4b76.asp
and
http://msdn.microsoft.com/library/d...
efint_4b76.asp
and
http://msdn.microsoft.com/library/d...enario_1bg3.asp
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
"Ihor Orobchuk" <Ihor.Orobchuk@.eleks.com> wrote in message
news:euC$51YoFHA.3256@.tk2msftngp13.phx.gbl...
> Hi gurus.
> I want to implement a full-text search support for texts of my native
> language in MS SQL Server 2005.
> But my language (Ukrainian) is not supported. So i would like to implement
> a module for this language by myself.
> Unfortunately i've failed to find what API i have to implement. Can
> anybody help me?
> --
> Tkx.
>|||Ihor,
While Ukrainian is not (yet?) a supported FTS language (a subset of
languages supported by SQL Server), the following is a list of supported FTS
languages (so far) in SQL Server 2005 Beta3:
select @.@.version -- SQL Server 2005 - 9.00.1187.07
select * from Sys.Fulltext_Languages
/* -- returns:
lcid name
-- ----
2052 Simplified Chinese
1028 Traditional Chinese
1030 Danish
1031 German
2057 British English
1033 English
3082 Spanish
1036 French
1040 Italian
1041 Japanese
1042 Korean
0 Neutral
1043 Dutch
1045 Polish
1046 Brazilian
2070 Portuguese
1049 Russian
1053 Swedish
1054 Thai
1055 Turkish
3076 Chinese (Hong Kong SAR, PRC)
5124 Chinese (Macau SAR)
4100 Chinese (Singapore)
(23 row(s) affected)
*/
Are you interested in doing this as an exercise or do you have actual
Ukrainian customer-base of SQL Server 2005 FTS-enabled applications in mind?
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:1E8AAD8A-EFD2-4975-B9AC-B5AF11B49216@.microsoft.com...
> Hi
> Ask this in the SQL Server 2005 newsgroups:
> http://communities.microsoft.com/ne...p=sqlserver2005
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Ihor Orobchuk" wrote:
>

No comments:

Post a Comment