Searching Styled and Unicode Text

[Ruslan Zasukhin]

on 5/1/03 4:16 PM, Shrink2Fit at aol.com at Shrink2Fit at aol.com wrote:

> Hi Ruslan,
> 
> The strategy of storing the style in a second binary field doesn't appear
> to work with Revolution. I could store two complete copies of my text,
> one with the html tags and one without, but that seems like a huge waste
> of space and not very elegant. What would be really great is a search
> option that would ignore html tags.

No Jonatan,

Believe me this must not be a feature of database engine.

Why you think you cannot split styled text on 2 fields in Rev ?
Revolution cannot do this?
Then make feature request to them.

> Thanks!
> 
> Jonathan
> 
> 
> Ruslan Zasukhin wrote on 5/1/2003 12:46 AM
> 
>>> Hi Ruslan,
>>> 
>>> I realize that I do not know a very basic fact. Can we search styled or
>>> html or unicode text for strings without needing to be concerned about
>>> special characters? For example, assume that I have a field with "see
>>> spot run" where "spot" is bold and "run" is italic. If I search for the
>>> plain text "spot run" will valentina find a match? Obviously it would be
>>> very desirable to store arbitrarily formatted text, but I could see how
>>> it might make problems if the formatting could not be ignored. Does
>>> Valentina ignore the formatting? Is there something else I am missing?
>> 
>> Hi Jonathan,
>> 
>> 1) you must store STYLE of text into SECOND Binary field:
>> 
>>        String[40]  -  FixedBinary[40]
>>        VarChar[200] -- VarBinary[200]
>> 
>> So the string field contains simple text, and bold style will not break for
>> your text search.
>> 
>> Some words about this are in V4RBRef.pdf
>> 
>> 
>> 2) Valentina do not work with Unicode yet.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------