Subject Re: [IBO] Problem with: IB_Query with order by ... COLLATE
Author pepmallorca
> You could try create a domain to column des as:
>
> 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.
>
> Luiz.

Hello:

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.

Thanks,

José,