Subject | Re: [IBO] Problem with: IB_Query with order by ... COLLATE |
---|---|
Author | pepmallorca |
Post date | 2002-03-05T23:42:06Z |
> 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.
>
> Luiz.
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é,