Quoting Helen's book:

Non-binary collations for ISO8859_1, for example, use full dictionary sorts, with
spaces and punctuation of fourth-order importance:

First order: A is different from B.
Second order: A is different from À.
Third order: A is different from a.
Fourth order: The type of punctuation symbol (hyphen, space, apostrophe) is
important.

For example:
Greenfly
Green fly
Green-fly
Greensleeves
Green sleeves
Green spot

If spaces and punctuation marks are treated instead as a first-order difference, the
same list would be sorted as follows:

Greenfly
Greensleeves
Green fly
Green sleeves
Green spot
Green-fly

BTW, I never tested this behavior with case/accent insensitive
collations. Maybe it is different and that would explain why you never
noticed anything "weird" ;-)

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

ABS> Carlos,

ABS> Em 10/8/2010 20:20, Carlos H. Cantu escreveu:

>> Right. I didn't mention ISO8859_1 because it sometimes causes
>> "interesting" (to not say weird) results, since it uses so called
>> dictionary sort ;)
>>
>> []s
>> Carlos H. Cantu
>> www.FireBase.com.br - www.firebirdnews.org
>> www.warmboot.com.br - blog.firebase.com.br
>>

ABS> Could you elaborate on this ?

ABS> I use it all the time and never found anything weird...

ABS> see you !


ABS> ------------------------------------

ABS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

ABS> Visit http://www.firebirdsql.org and click the Resources item
ABS> on the main (top) menu. Try Knowledgebase and FAQ links !

ABS> Also search the knowledgebases at http://www.ibphoenix.com

ABS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ABS> Yahoo! Groups Links