farideh_en
دوشنبه 19 شهریور 1386, 13:58 عصر
سلام
می خواستم بدونم چه جور میشه در sql server2005 در قسمت full text زبان عربی یا فارسی را اضافه کرد ؟
من از روش زیر استفاده کردم اما نشد :
Adding support for your own language word breaker
In SQL 2005 you can add support for your own language by adding a key to HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language. For example in order to add support for Arabic, follow these steps:
Download and install the Arabic word breaker from:
http://www.microsoft.com/middleeast/arabicdev/beta/search/ (http://www.microsoft.com/middleeast/arabicdev/beta/search/)
Run the installation program
Install Complex Script components – open up Regional Settings, click on the Languages tab, and select Install files for complex script and right to left languages.file:///C:/Documents%20and%20Settings/fl/Desktop/full_text/SQL%20Server%20Full%20Text%20Search%20Language%20F eatures_files/130-image001.jpg
Add the Arabic key: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language\Arabic-EG with the following values:
Locale (dword) 1025 (decimal)
NoiseFile (String) c:\temp\Arabic.txt
StemmerClass (String)
TsaurusFile (String) c:\temp\ArabicThesaurus.txt
WordBreakerClass (String) {3E0C67A6-38F8-43b6-BD88-3F3F3DAC9EC1}
Add the following key
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\CLSID\{3E0C67A6-38F8-43b6-BD88-3F3F3DAC9EC1}
with a string value of lrar32.dll.
Copy lrar32.dll and lrar32.lex from C:\Program Files\SharePoint Portal Server\Bin\ to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
Issue a call to exec sp_fulltext_service 'update_languages' and restart SQL Server. It is critical that you review your license, or contact your local Microsoft office, with regard to possible licensing issues surrounding use of the Arabic word breaker in your SQL Server search application. The Arabic word breaker (http://www.microsoft.com/middleeast/arabicdev/beta/search/) seems to be in perpetual beta and it is not clear whether it is licensed for SQL Server 2005. It appears that there are no licensing restrictions on other third-party supplied SQL 2005 word breakers, but they are not supported by Microsoft.
می خواستم بدونم چه جور میشه در sql server2005 در قسمت full text زبان عربی یا فارسی را اضافه کرد ؟
من از روش زیر استفاده کردم اما نشد :
Adding support for your own language word breaker
In SQL 2005 you can add support for your own language by adding a key to HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language. For example in order to add support for Arabic, follow these steps:
Download and install the Arabic word breaker from:
http://www.microsoft.com/middleeast/arabicdev/beta/search/ (http://www.microsoft.com/middleeast/arabicdev/beta/search/)
Run the installation program
Install Complex Script components – open up Regional Settings, click on the Languages tab, and select Install files for complex script and right to left languages.file:///C:/Documents%20and%20Settings/fl/Desktop/full_text/SQL%20Server%20Full%20Text%20Search%20Language%20F eatures_files/130-image001.jpg
Add the Arabic key: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language\Arabic-EG with the following values:
Locale (dword) 1025 (decimal)
NoiseFile (String) c:\temp\Arabic.txt
StemmerClass (String)
TsaurusFile (String) c:\temp\ArabicThesaurus.txt
WordBreakerClass (String) {3E0C67A6-38F8-43b6-BD88-3F3F3DAC9EC1}
Add the following key
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\CLSID\{3E0C67A6-38F8-43b6-BD88-3F3F3DAC9EC1}
with a string value of lrar32.dll.
Copy lrar32.dll and lrar32.lex from C:\Program Files\SharePoint Portal Server\Bin\ to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
Issue a call to exec sp_fulltext_service 'update_languages' and restart SQL Server. It is critical that you review your license, or contact your local Microsoft office, with regard to possible licensing issues surrounding use of the Arabic word breaker in your SQL Server search application. The Arabic word breaker (http://www.microsoft.com/middleeast/arabicdev/beta/search/) seems to be in perpetual beta and it is not clear whether it is licensed for SQL Server 2005. It appears that there are no licensing restrictions on other third-party supplied SQL 2005 word breakers, but they are not supported by Microsoft.