Home Dashboard Directory Help
Search

Greek full text search support by Kostas Pantos


Status: 

Active


50
0
Sign in
to vote
Type: Suggestion
ID: 384017
Opened: 11/25/2008 6:00:44 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Full text search is probably the best tool when it comes to searching through large amount of database data and has come a long way since the early versions of SQL server in of performance but also with more languages, being supported in each new version. But even though SQL Server 2008 now supports more than 50 diverse languages, according to msdn documentation, there is still no support for Greek in Full Text Search preventing us from building Greek localized applications that will take advantage of this SQL server feature.
So we would like Greek support in SQL server 2008 Full Text Search as soon as possible.
Details
Sign in to post a comment.
Posted by Microsoft on 2/15/2011 at 5:42 PM
This is in regards to Microsoft SQL Server Fulltext Search and Index Support for Greek Language. We are actively considering adding this support in the next release of SQL Server (code named "Denali"). Thank you for your request.

With best regards
Microsoft SQL Server Search Team
Posted by sakis[_paok on 10/2/2010 at 1:55 AM
i have a pc pursuited in us but i live in greece .the pc has windows 7 home and i want to install greek language but i cant ,at winwows upadte it is only for windiws 7 ultimate.
any suggestions to solve my problem?
Posted by sakis[_paok on 10/1/2010 at 3:18 PM
re paidia exw tna pc apo amerikh me windows 7 home kai den borw na ta kanw na deixnoun ellinika.any suggestions?
Posted by fotis12 on 4/20/2010 at 4:16 AM
So, when shall we finally have full greek support in FTS?
Last week there was a presentation here in Athens for SQL Server 2008, by Microsoft Helllas
It was at least pathetic to watch very good professionals, trying to demosntrate the sql server 2008 features including a small demo with english words for the FTS.
Im sure it was embarassing for them, trying to demostrate features to a Greek audience, that is finally useless unless you decide to support our native language.
FTS is completely useless for us if you do not support greek.
Better leave it out from all future presentations here in Greece.
we try to work for you guys selling your products and implementing solutions with your tools and you dont support us at all, you turn your backs.
so, as pointed out on
http://www.dotnetzone.gr/cs/blogs/pkanavos/archive/2010/01/25/how-to-load-the-greek-stemmer-and-word-breaker-for-sql-server-full-text-search.aspx
we could tweak the registry and use SharePoint dll's like grclr.dll and grcste.dll
Can we distribute those dll's in our existing sql server installations?
Why dont you just include it in the installation?

Posted by Adespotos on 12/18/2008 at 7:11 AM
Customers demand support for Greek and they are not willing to pay extra, pkanavos is right
Posted by Panagiotis Kanavos on 12/10/2008 at 2:18 AM
The lack of a Greek FTS stemmer was a sore issue with all projects I've worked on for the last 15 years. In the past, the only alternative was to go with Oracle - and people did. Lack of FTS has held back adoption of SQL Server in document management projects.

But that was before Google and Sharepoint. Now customers need and demand Greek stemming and they can get a cheap alternative. I've deployed Sharepoint at over a dozen customers including a ministry, half a dozen banks and a couple multinational industries, and the lack of Greek stemming is always a serious problem.

Buying a third-party stemmer is not an option, because Microsoft has unwittingly choked this market. No-one is willing to create a product that will die the moment Microsoft decides to implement its own stemmer for free. What's more, customers expect Greek FTS to be included in the lincensing fees they have already paid, and are not willing to pay extra for it.
This has happened in the past, when the release of a mediocre spell checked for Office killed all other Greek spell checking products.

By overlooking Greek FTS, Microsoft may be hinderning not just SQL Server but any product that uses the same FTS technology, including Sharepoint and Search Server and forcing customers to consider Google.
Posted by George Birbilis on 12/2/2008 at 3:20 PM
Can you provide pointers to Word Breaker API? Does the breaker API expect to be fed with Unicode (that is SQL Server does any needed text encoding convertion internally first) or does it have to also support the various Greek encodings (ISO, Windows, DOS, etc.)?
Posted by Microsoft on 12/1/2008 at 2:08 PM
Thanks for your feedback.

We totally understand your need for Greek, unfortunately, it is not something we can get in upcoming SP (PCUs). We do not own the components implementing these languages and we need to get them from another team outside SQL Server division. Once this team has new or better word breakers for SQL Server, then we do everything possible to integrate them in the product (as we did in SQL Server 2008 as you well know). At this point, I am afraid you will need to wait until our next major release comes (hopefuly with Greek out of the box) or install a 3rd party Greek Word Breaker in your server (SQL Server will be able to load it and use it for your needs).

Thanks for your feedback again.
Posted by Microsoft on 12/1/2008 at 2:08 PM
Thanks for your feedback.

We totally understand your need for Greek, unfortunately, it is not something we can get in upcoming SP (PCUs). We do not own the components implementing these languages and we need to get them from another team outside SQL Server division. Once this team has new or better word breakers for SQL Server, then we do everything possible to integrate them in the product (as we did in SQL Server 2008 as you well know). At this point, I am afraid you will need to wait until our next major release comes (hopefuly with Greek out of the box) or install a 3rd party Greek Word Breaker in your server (SQL Server will be able to load it and use it for your needs).

Thanks for your feedback again.
Posted by Microsoft on 12/1/2008 at 2:08 PM
Thanks for your feedback.

We totally understand your need for Greek, unfortunately, it is not something we can get in upcoming SP (PCUs). We do not own the components implementing these languages and we need to get them from another team outside SQL Server division. Once this team has new or better word breakers for SQL Server, then we do everything possible to integrate them in the product (as we did in SQL Server 2008 as you well know). At this point, I am afraid you will need to wait until our next major release comes (hopefuly with Greek out of the box) or install a 3rd party Greek Word Breaker in your server (SQL Server will be able to load it and use it for your needs).

Thanks for your feedback again.
Posted by George Birbilis on 11/26/2008 at 2:27 PM
why not have Unicode text search btw?
Sign in to post a workaround.