Hi,

I use Informix in my application. I need to make search case-insensitive (if I look for A I have to find a,Á,Ä,...)
I have two solution:

1. I could do a procedure what replace À to A, a to A,... and also create indexes.
2. I could have an additional column in the tables with all letters in uppercase and use that columns in the queries

what solution do you think that is the correct?, could the solution 1 have impact in the performance?

Thank in advance

Hello,

I think the first procedure is much better than the second one, it's only a matter of replacing the one that is incorrect with the correct one. However it depends whether the first one or the second one will work ? to make sure just try them both, in my opinion.
__________________________________________________ _______________
cannabis seeds