Hello
Perhaps the problem lies in the different ordering of NULL between FB1.5 and 2.x (look at http://www.firebirdsql.org/manual/nullguide-sorts.html )
Try to add a "Nulls last" to have the same ordering as in FB <2.x.

--- In IBObjects@yahoogroups.com, Andrei Luís <compuvale.software@...> wrote:
>
> Hello,
>
> I'm using IBO 4.8.7 on Delphi 2006 Win32.
>
> This week I finnaly moved to FB 2.1.2, I was working with FB 1.5.5.
>
> What I did to my base:
> - with FB 1.5: extract DDL metadata, and change some collates from
> PXW_INTL850 to WIN_PTBR
> - with FB 2.1: create the new FDB file and pump data from the FB 1.5 FDB
> file using IBDatapump
>
> After that, I experienced some search problem using TIB_Lookupcombo,
> consider the above fields:
>
>
> NAME varchar(50) collate WIN_PTBR (with FB 1.5 the collate was
> PXW_INTL850)
> CONTACT varchar(30) collate WIN1252 (same collate on FB 1.5)
>
>
> Well, nothing was changed in Delphi Project, so, TIB_Query and
> TIB_Lookupcombo properties are OK.
>
> After some tests, I realized that the problem is on NULL values at the
> searched fields. If I have two or more lines with NULL values in the
> searched field, the search don't work. I can click on TIB_Lookupcombo and
> navigate on data, it's all there, but if I type something on keyboard,
> nothing happens.
> I run 'DELETE FROM MYTABLE WHERE NAME IS NULL', and the search is working
> again. I inserted one field with null value and search is ok, but if I
> insert one more null value the search is gone again. I got the same behavior
> independent the collate. But If I use the original FB 1.5 base, running on
> FB 2.1 server, the nulls rows don't affect the search.
>
> What can I do? I can delete the rows that have null in name collumn, but I
> can't delete the rows that have null in collumn contact. And I'd like to
> maintain the collate WIN_PTBR for ordering purposes.
>
> Is there any other sollution to this issue?
>
> Thanks,
> Andrei
>
>
> [Non-text portions of this message have been removed]
>