SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Full-Text Search – Thesaurus Languages


Full-Text Search – Thesaurus Languages

Author
Message
demonfox
demonfox
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2113 Visits: 1192
L' Eomot Inversé (3/19/2013)
Good question, but the definite cultural bias is perhaps unfortunate. I suppose it's fair enough, as the default installation will use LCID 1033, not 2057. But there may be some Brits around for whom teseng.xml is the right file and they wouldn't stand much chance of spotting the right answer, would they?


totally , out of the context , but there is no british english ; there is australian english, there is american english .. but only English , when it comes to britain ...:-P

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm
sestell1
sestell1
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3426 Visits: 3507
Interesting question. In researching this, I was amazed how many posts I found stating that SQL Server needed to be restarted after changing a thesaurus file.
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25070 Visits: 12484
Hugo Kornelis (3/19/2013)
I turned out to be right, but the reference leaves me wanting more. It points to a list of language codes in the format xx-YY (four letters seperated by a dash), not the three-letter format required for thesaurus files. It appears as if the three-letter format is always found by removing the dash and the last letter from the listed language code, but this is not described on that web page. And after following the link on that page to http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx (which is listed as being documentation for Windows Vista!), I see a table that suggests that this is not the case - but that also includes many languages that I believe not to be supported by SQL Server, so I'm not sure how relevant this is.

Can anyone fill me in on the missing details?

Well, the only way I know to get this is to start with the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSearch\Language]\MSSearch\Language or the equivalent on your machine (on my machine MSSQL10_50.MSSQLSERVER is the directory name for the instance of SQL server within the MSSQL directory). Each subkey under that includes a mapping from template xml filename to locale ID - the subkey name is sometimes in the three character format, sometimes in the 5-character format, but the values are always the filename using the 3-character format. This will provide all 48 (or 44, excluding duplicates) of the 33 (:w00tSmile supported languages.
Mappings from 33 locale ids to language are given on the sys.languages BOL page. What the other 15 locale ids is probably documented somewhere else, but may be irrelevant.

Tom

(Bob Brown)
(Bob Brown)
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1047 Visits: 1145
Hugo Kornelis (3/19/2013)

Can anyone fill me in on the missing details?


I don't know if this is any help but it is what I used to answer this question:

http://msdn.microsoft.com/en-us/library/ms142491.aspx

http://msdn.microsoft.com/en-us/library/ms142491(v=sql.100).aspx
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18187 Visits: 12426
L' Eomot Inversé (3/19/2013)
Hugo Kornelis (3/19/2013)
I turned out to be right, but the reference leaves me wanting more. It points to a list of language codes in the format xx-YY (four letters seperated by a dash), not the three-letter format required for thesaurus files. It appears as if the three-letter format is always found by removing the dash and the last letter from the listed language code, but this is not described on that web page. And after following the link on that page to http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx (which is listed as being documentation for Windows Vista!), I see a table that suggests that this is not the case - but that also includes many languages that I believe not to be supported by SQL Server, so I'm not sure how relevant this is.

Can anyone fill me in on the missing details?

Well, the only way I know to get this is to start with the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSearch\Language]\MSSearch\Language or the equivalent on your machine (on my machine MSSQL10_50.MSSQLSERVER is the directory name for the instance of SQL server within the MSSQL directory). Each subkey under that includes a mapping from template xml filename to locale ID - the subkey name is sometimes in the three character format, sometimes in the 5-character format, but the values are always the filename using the 3-character format. This will provide all 48 (or 44, excluding duplicates) of the 33 (:w00tSmile supported languages.
Mappings from 33 locale ids to language are given on the sys.languages BOL page. What the other 15 locale ids is probably documented somewhere else, but may be irrelevant.


Thanks, Tom!

It's simply incredible that Microsoft makes it so hard to find the correct file to use for adding thesaurus entries for a language.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18187 Visits: 12426
(Bob Brown) (3/19/2013)
Hugo Kornelis (3/19/2013)

Can anyone fill me in on the missing details?


I don't know if this is any help but it is what I used to answer this question:

http://msdn.microsoft.com/en-us/library/ms142491.aspx

http://msdn.microsoft.com/en-us/library/ms142491(v=sql.100).aspx


Thanks, Bob.

But I was specifically looking for how to find the three-letter language code for any give language. Those pages do not include that information (unless I overlooked it).


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Toreador
Toreador
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3772 Visits: 8123
demonfox (3/19/2013)
only English , when it comes to britain ...


I'm looking forward to Tom's reply to that one ;-)
mtassin
mtassin
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7020 Visits: 72521
+1 Smile I recognized that I should be looking for enu... in my moment of mental distraction.

good question though... it's one of those little things that isn't hard to miss.



--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Revenant
Revenant
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12137 Visits: 5009
(Bob Brown) (3/19/2013)
Yay. Great question. Had to do a lot of research to get it right. Thanks.

+1

(50 minutes of study)
demonfox
demonfox
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2113 Visits: 1192
Hugo Kornelis (3/19/2013)
(Bob Brown) (3/19/2013)
Hugo Kornelis (3/19/2013)

Can anyone fill me in on the missing details?


I don't know if this is any help but it is what I used to answer this question:

http://msdn.microsoft.com/en-us/library/ms142491.aspx

http://msdn.microsoft.com/en-us/library/ms142491(v=sql.100).aspx


Thanks, Bob.

But I was specifically looking for how to find the three-letter language code for any give language. Those pages do not include that information (unless I overlooked it).


I am not sure , if this is anywhere related to iso639-2 codes ..

These are the references I could find ..

http://www.loc.gov/standards/iso639-2/php/code_list.php

here is a discussion reference and an included further references .. I think, this might the standard followed by ms in sql server.. but, then again , a guess ;-)
http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/efa9b596-3bc4-4be7-aeeb-4d97ad31f1dd

http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.threeletterisolanguagename.aspx


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search