|Subject||Re: [IBO] Problem with: IB_Query with order by ... COLLATE|
> You could try create a domain to column des as:Hello:
> CREATE DOMAIN DOM_DES VARCHAR( 80 )
> COLLATE ES_ES
> and define your column des as DOM_DES.
> After this, create your index on (cod,des)
> I don't tested, but I believe can to do some difference.
I was testing your idea of the domain, the collate and the order by,
and I think it works. I have not reply you until now, because I
would want test it with a large number of records (and I have not
time). If it doesn't work, I'll notice you.
I had a problem (with size 80), it gives me one error similar to:
'Key too big for the index'
I reduced the size to 60, and seems works good.