Click here to Skip to main content
Click here to Skip to main content

Danish Language Installation for Full Text Search Index

, 18 Apr 2013
Rate this:
Please Sign up or sign in to vote.
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.

Introduction 

While working with full text search index facility provided by SQL Server there are a number of language supported by it as a language for word breaker.

The default languages it provides are:  

Arabic, Bengali (India), Brazilian, British English, Bulgarian, Catalan, Chinese (Hong Kong SAR, PRC), Chinese (Macau SAR), Chinese (Singapore), Croatian, Danish, Dutch, English, French, German, Gujarati, Hebrew, Hindi, Icelandic, Indonesian ,Italian, Japanese, Kannada, Korean, Latvian, Lithuanian, Malay – Malaysia, Malayalam, Marathi, Neutral, Norwegian (Bokmål), Polish, Portuguese, Punjabi, Romanian, Russian, Serbian (Cyrillic), Serbian (Latin), Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Tamil, Telugu, Thai, Traditional Chinese, Turkish, Ukrainian, Urdu, Vietnamese. 

MSSQL 2008 R2 does not  provide support for Danish, Polish, Turkish by default.

To avail Danish (same for other two languages also) language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for Danish.

Using the Code 

MSDN provides this facility to add language which is manual and a time consuming process. And to overcome the whole manual process, I have created a registry file that may help to add registry keys for Danish language. The attached registry file will automatically add a registry key for Danish (DanishFullTextRegistryFile.reg)

Caution: Registry contains editing

The path for default instance name is MSSQLSERVER. If the target server contains a different name then there needs change in the registry file. 

You can know your instance name by running the following query in your query window:

SELECT @@SERVERNAME OR 

SELECT SERVERPROPERTY('InstanceName')  OR

select * from sys.sysservers

If it is other than MSSQLSERVER, we have to make changes in DanishFullTextRegistryFile.reg file. Open the DanishFullTextRegistryFile.reg file in Notepad and find MSSQL10.MSSQLSERVER and replace it with your instance name MSSQL10_50.DEV08R2.

You can find it from the attached doc document.  

Save the registry file and run it. 

After getting a message for successful upload, we have to update the full text service. The service can be updated by running the following query: 

EXEC sp_fulltext_service @action='load_os_resources', @value=1; 

EXEC sp_fulltext_service 'update_languages';

You can check if languages are updated or not by running the below query.

SELECT * FROM
sys.fulltext_languages ORDER
BY name  
--(Danish - 1030)

You will have to find out Danish language as a name and 1030 as its LCID. 

If it is available then the process runs successfully and now you can make changes to your full text search index and change the language breaker to Danish language.

(Note: This installation is only needed for the Danish version, it is not required for Swedish or English language versions.)

Thanks for reading the article, please let me know if I missed anything.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Aadhar Joshi

India India
No Biography provided

Comments and Discussions

 
GeneralLanguages provided by SQL Server PinmemberAvelino Ferreira5-Jun-14 11:43 
GeneralMy vote of 5 PinmemberThe Sql Coder26-Oct-12 1:31 
GeneralMy vote of 5 PinmemberThe Sql Coder22-Oct-12 19:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 18 Apr 2013
Article Copyright 2012 by Aadhar Joshi
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid