Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Full-Text Search – Thesaurus Languages Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 6:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
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 ...


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1432618
Posted Tuesday, March 19, 2013 7:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:18 AM
Points: 1,314, Visits: 2,268
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.
Post #1432621
Posted Tuesday, March 19, 2013 7:03 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:07 AM
Points: 8,745, Visits: 9,293
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 () 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
Post #1432624
Posted Tuesday, March 19, 2013 7:03 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
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
Post #1432626
Posted Tuesday, March 19, 2013 7:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 5,984, Visits: 8,242
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 () 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
Post #1432636
Posted Tuesday, March 19, 2013 7:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 5,984, Visits: 8,242
(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
Post #1432638
Posted Tuesday, March 19, 2013 8:28 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
demonfox (3/19/2013)
only English , when it comes to britain ...


I'm looking forward to Tom's reply to that one
Post #1432685
Posted Tuesday, March 19, 2013 8:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:04 AM
Points: 3,675, Visits: 72,433
+1 :) 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
Post #1432689
Posted Tuesday, March 19, 2013 10:19 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
(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)
Post #1432762
Posted Tuesday, March 19, 2013 12:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
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
Post #1432843
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse