sql server full text search:
Abbas,
While SQL Server (7.0 and 200) both Support Arabic, Full-Text Search only
supports a "subset" of SQL Server supported languages and Arabic is not one
of those languages. However, you can use the "Neutral - Language for Word
Breaker" when you setup the FT Catalog via the FT Indexing Wizard under SQL
Server 2000. If you're using SQL Server 7.0, you will have to set the entire
server to the "Neutral" language setting via sp_configure. The supported
subset of languages supported by SQL Server for FTS is documented in the
Books Online (BOL)....
In addition to the BOL documentation, there is now on MSDN - "Arabic
Language Support in Microsoft SQL Server 2000" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_arabicsupport.asp
that might also be helpful to you.
Additionally, and assuming that the HTML documents that you are storing in
your IMAGE column PageText are in Arabic, could you confirm that all of the
HTML files have the correct language identifiers? Specifically, confirm if
there are any <meta> tags within the <header> tags and that they are
"<head><meta name='ms.locale' content='EN-US'></head>" vs. "<meta
name="MS.Locale" content="AR">" (the latter is Arabic). For more info see
the "HTML Filter" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/ixufilt_2uuq.asp
as well as
http://www.otal.umd.edu/uupractice/non_english/
Run a T-SQL LIKE on the source HTML files (if possible & if available)
using WHERE LIKE '%ms.locale%' and check the results for non EN-US
"content". The sp_help_fulltext* language column value is correct (0 =
Neutral).
Regards,
John
[quoted text, click to view] "noor" <najafian@noornet.net> wrote in message
news:enCM377wDHA.3196@TK2MSFTNGP11.phx.gbl...
> Hi All,
>
> I have Unicode Arabic HTML data in an Image column (PageText) and (htm) in
> PageFormat column and Full Population too.
> But this query has no result.
>
> SELECT * FROM tblBookPages WHERE CONTAINS(PageText, ' "any arabic word" ')
>
> Please help me.
>
> My Server Configuration
> *******************
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.0 (Build 2195: Service Pack 2)
> -------------------
> us_english
> -------------------
> 6 NajehBookPages C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA 6 1
> -------------------
> dbo tblBookPages PK_tblBookPages 8 1 NajehBookPages
> -------------------
> dbo 340248317 tblBookPages PageText 2 PageFormat 7 0
> -------------------
> CREATE TABLE [dbo].[tblBookPages] (
> [PageText] [image] NULL ,
> [PageFormat] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [RowID] [bigint] IDENTITY (1, 1) NOT NULL
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> **************
>
> Regard,
> abbas
>
>
>
>
>
