Can u exec a command to extract collation? show lc_collate and select * from blob order by barf;
Just to check against my db. --Robson 2009/2/19 Alessandro Ronchi <[email protected]> > > On Thu, Feb 19, 2009 at 3:12 PM, Robson Dantas <[email protected]> > wrote: > > Hi Alessandro. > > > > I´m not a Satchmo expert, but I´ve changed my database collation to CI > (case > > insensitive) and the search works with no problem. Which database are u > > using ? Can u check your collation and send here ? > > I'm using postgresql. > It's strange because I've checked the search listeners and it uses > icontains, which should be case unsensitive. > > > -- > Alessandro Ronchi > Skype: aronchi > http://www.alessandroronchi.net > > SOASI Soc.Coop. - www.soasi.com > Sviluppo Software e Sistemi Open Source > Sede: Via Poggiali 2/bis, 47100 Forlì (FC) > Tel.: +39 0543 798985 - Fax: +39 0543 579928 > > Rispetta l'ambiente: se non ti è necessario, non stampare questa mail > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
