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
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1527 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
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2547 Visits: 3463
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.
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14358 Visits: 12204
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)
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11050 Visits: 11998
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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11050 Visits: 11998
(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
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

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


I'm looking forward to Tom's reply to that one ;-)
mtassin
mtassin
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4828 Visits: 72518
+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
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7373 Visits: 4864
(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
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1527 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