Hello,
I try to prepare my own word generator to use Windows ANSI Code Page 1250 character set. To start I removed some characters from SpaceChars set and add them to IncludeChars set, all that in initialization section of word generator unit, no other modifications. To test it I registered my word generator in ElevateDb Manager and created an appropriate text index. The needed characters are now visible in searches as I expected but there is a side effect - the SELECT of the following type:
SELECT * FROM Customer WHERE Notes CONTAINS '*invest*', so with leading asterisk, returns always empty result sets.

Regards,
JC

Janusz


Just checked with my custom word generator/text index and I get the same.

Roy Lambert

Janusz,

<< I try to prepare my own word generator to use Windows ANSI Code Page 1250 character set. To start I removed some characters from SpaceChars set and add them to IncludeChars set, all that in initialization section of word generator unit, no other modifications. To test it I registered my word generator in ElevateDb Manager and created an appropriate text index. The needed characters are now visible in searches as I expected but there is a side effect - the SELECT of the following type:
SELECT * FROM Customer WHERE Notes CONTAINS '*invest*', so with leading asterisk, returns always empty result sets. >>

Please email me your word generator project, and I'll take a look.  I just tried this with the built-in word generation, and it isn't an issue, so there must be something particular in your word generator that is causing an issue.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


Native is fine - custom isn't. My word generator is in the extensions if you want to have a look at that

Roy Lambert

Roy,
I've just sent that custom word generator to Tim. I tried to use your wg before but noticed that behaviour so I tried something as simple as possible - with the same result.

Janusz

Janusz

>I've just sent that custom word generator to Tim. I tried to use your wg before but noticed that behaviour so I tried something as simple as possible - with the same result.

I never tested for it before because whilst I can see the point of a wildcard at the end of  a word I fail to have a use for one at the beginning of a word. I'm sure there is a valid use for it I just don't have it


Roy

Tim,
have you got my email?

Janusz

Janusz

<< have you got my email? >>

Yes, I have it. I will be taking a look shortly.

Tim Young
Elevate Software
www.elevatesoft.com

Janusz,

Okay, I finally got a chance to try this out, and I'm not seeing any issues here with the test data that I'm trying.  Your custom word generator behaves the exact same way as the built-in word generation code.

Of course, I'm using a test table that uses US English words, so I can't really reproduce your situation exactly.  If you want to send me your database, I can try it with it.

Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Okay, I finally got a chance to try this out, and I'm not seeing any issues here with the test data that I'm trying. Your custom word generator behaves the exact same way as the built-in word generation code.
>
>Of course, I'm using a test table that uses US English words, so I can't really reproduce your situation exactly. If you want to send me your database, I can try it with it.


I get the same problem with my word generator using the default ANSI_CI collation for all text columns. ARe you trying it with UNICODE?

Roy Lambert