Re: [Firebird-devel] Case-insensitive collations

[Carlos H. C. <fb...@wa...>]

Peter,

PJ> There is no substitute for leartning. If you want to know about
PJ> state-of-the-art collations, there is no substitute for starting here:
PJ> http://www.unicode.org/reports/tr10/

Thanks, I will check it.

>> I tend to disagree with you... at last in
>> Brazil, people are requesting for a long time an accent/case
>> insensitive collation. 

PJ> For what use case?

Example: Here we have a very common name for people: "João" - this is
the correct way of writing it, BUT, people used to write it in many
diferent ways, so we can have in the same "table":

João
joão
joao
Joao
JOAO
....

The same thing happens with many other names and words (ie: José, cachaça, etc.)

People here would like to have all the variations ordered and compared as
the same. Ie:

c = C = ç = Ç
a = A = á = Á = ã = Ã = ä = Ä = â = Â = â = Â = à = À etc...


PJ> Give me the requirements spec. What exact behaviour do you want for this
PJ> collation?

I think my previous explanation gives you a good idea of what we
want/need. BTW, isnt that a default expected behavior of a case/accent
insensitive collation?


[]s
Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br