Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread FTS Index problem
Mon, Mar 19 2007 10:30 AMPermanent Link

Igor Colovic
I have a strange problem with FTS index.

Table have to fields
ID : String [10]
Heading : Memo;

If I create Index on Windows XP SP2 machine it is different size from one created on
Windws 2000, Windows XP, Windows 2003 SP1.

The real problem is searching.
Using FTS index created on Windows XP SP2 on any other OS return subset or no result
(depending or query).

It is the same other way around. Index created on Win2000/XP/2003 return subset or no result.

Table is uncompressed and unencrypted.

I am using last trial.



Mon, Mar 19 2007 5:41 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Igor,

<< I have a strange problem with FTS index.

Table have to fields
ID : String [10]
Heading : Memo;

If I create Index on Windows XP SP2 machine it is different size from one
created on Windws 2000, Windows XP, Windows 2003 SP1.

The real problem is searching.

Using FTS index created on Windows XP SP2 on any other OS return subset or
no result (depending or query).

It is the same other way around. Index created on Win2000/XP/2003 return
subset or no result. >>

What Locale are you using for the table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Mar 20 2007 5:41 AMPermanent Link

Igor Colovic
<<What Locale are you using for the table ?>>

Serbian (Latin)

I have noticed that only Windows XP SP2 have new locale Serbian (Latin, Bosnia and
Herzegovina). I do not know if they changed anything in code of the library.

If You want I can send you some sample Serbian texts for test.
Tue, Mar 20 2007 5:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Igor,

<< Serbian (Latin)

I have noticed that only Windows XP SP2 have new locale Serbian (Latin,
Bosnia and Herzegovina). I do not know if they changed anything in code of
the library.  >>

Yes, they added a few new locales, including the Serbian (Latin) locale, but
they must have changed something else if you're getting different results
with the same locale ID.  DBISAM stores the actual locale ID in the table,
not just the identifying name.

Did you use the Serbian (Latin) locale on the other systems, or was it named
differently ?  They may have changed the behavior of the sub-language
designation.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Mar 21 2007 5:49 AMPermanent Link

Igor Colovic
<<Yes, they added a few new locales, including the Serbian (Latin) locale, but
they must have changed something else if you're getting different results
with the same locale ID.  DBISAM stores the actual locale ID in the table,
not just the identifying name.>>

Yes I know.

<<Did you use the Serbian (Latin) locale on the other systems, or was it named
differently ?  They may have changed the behavior of the sub-language
designation.>>

No the name is the same. But it should be no difference because Serbian (Latin), Serbian
(Latin, Bosnia/Herzegovina), Croatian, Croatian (Bosnia/Herzegovina) are all the same
language. All the same letters, collations, everything.

If I use ANSI Standard Locale everything is ok. All Serbian specific letters are
uppercased Ok. My system locale (For non-unicode) is English (US).

Another thing. If I use Croatian file size is the same but binary they are different.
(between Windows 2003 and Windows XP SP 2).

Microsoft obviously changed something in all of those languages. I can not find anything
on the Web about that.

For now I will use ANSI Standard as it finishes the job.

P.S. Naturally  Vista is behaving same as Windows XP SP 2.
Wed, Mar 21 2007 4:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Igor,

<< Microsoft obviously changed something in all of those languages. I can
not find anything on the Web about that. >>

They've done this a couple of times between Win9X and the Win2000+.  It's
very hard to find information on what changes were made to the locale
behaviors.

<< For now I will use ANSI Standard as it finishes the job. >>

Yes, ANSI Standard won't deviate. Smiley

P.S. Naturally  Vista is behaving same as Windows XP SP 2. >>

Yes, I would expect that they would behave the same.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image