Re: Full Text Search of mulitple language using Neutral Word Break

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Hilary,

If a column contains both chinese and english characters (E.g. I will not
be able to split the information into one column chinese and one column
english), I will not be able to search across the two languages?

Even if I store in different columns, it will still be the same content
(With english and chinese characters) and the search will not be correct.

Please advise.

Thanks.

"Hilary Cotter" wrote:

No, they should be stored in different columns and use different word
breakers for each column.
"Soh Chee King" <Soh Chee King@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9BA3FA18-34B9-4E38-A86E-0F992775707A@xxxxxxxxxxxxxxxx
Hi,

To enable support of FTS of multiple languages, we are using neutral word
breaker in ms sql 2000 for our application.

Unfortunately, there seems to be a limitation in the word breaker. It
does
not support part content of words which is crucial for chinese search.

Is there a fix or alternative solution for searching both chinese and
english characters?



.

Relevant Pages

  • Using the IME on Chinese (Simplified) localized version of WM5.0
    ... I have a question on using the IME window that pops up on a Chinese ... How do I enter just English characters in this setup? ... but we are having problems testing out the telnet infrastructure ...
    (microsoft.public.pocketpc)
  • Chinese characters
    ... I am using IE 6 from work and I work with several Chinese people, ... sure the chinese language pack has been installed. ... in english there will be several chinese characters replacing traditional ... english characters in the text. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: FT Index on column with multiple language doesnt work - any ideas
    ... specifying the English word breaker it interprets the contents of the row to ... Chinese, or the language settings for your Word document are Chinese, or you ... > With the English language breaker, ...
    (microsoft.public.sqlserver.fulltext)