Sorting compound names

[Ruslan Zasukhin]

On 9/22/04 12:39 AM, "jda" <jda at his.com> wrote:

> What these folks want is the ability to alter record sorting so that
> it ignores prefixes in surnames. This is apparently standard in
> German, Swedish, Dutch, and no doubt other languages.
> 
> I don't know of open source dbs that do this, but as I said, EndNote
> (a competitor of mine) lets you create a list of words that are to be
> ignored when sorting names (e.g. von, van, de, etc.). Papyrus (a now
> defunct ex-competitor) allows "German sorting rules", which did much
> the same. This approach, to provide this sort of sort as an option,
> should satisfy most folks who want this feature I think.

Look,

We can try implement in 2.0 for fields with IndexByWords
The option 

1) min length of words to index
    
    e.g. 3

    then words: and or a the
    will not go into index at all


2) List of ignore words.

So if record is 
    
    von XXXXXX

Then into index will go only XXXX part.

 
> I'll be trying the tmp table approach to see if I can do just this.
> Given how fast Valentina is, I think performance will probably just
> fine (most sorts will be on less than 200 records).

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------