Re: Case Sensitive Issues Informix

There are two possible "workarounds": 1. Upgrade to version 7.3 of Informix IDS which support this functionality. 2. If an upgrade isn't possible create an extra field in the table that contains the lower (or upper) case version of what you have in the original field used in the order by and like parts of your sql and use this extra field for those purposes while displaying the original field. This does of course require this extra field to be maintained by your application, something that may be some work. However you gain a significant advantage (even with 7.3) in that you can create an index on such a field. A third alternative is of course to upgrade to IDS with Universal Data Option (ver. 9.x of the engine) which also give you the ability to create indexes on functions like upper/lower and any other. This can increase the performance of like as well as order by a lot. On Fri, 07 Aug 1998 15:10:19 GMT, jeverson@erac.com wrote: >I've been creating ASP pages connecting to a SQL Server as the database. The >request was made of me to change to use Informix instead. I though no problem >just change the ODBC datasource to connect to Informix, right... wrong. I've >ran into two problems. >1st: > >The results of my SQL ORDER BY clause are not as I expected. For instance I >am now getting a result like: > >AAA >BBBB >aa > >instead of > >aa >AAA >BBBB > >2nd: If I do a SQL call using a LIKE then the criteria must be in the same >case as it is in the database. > >I've looked at their documentation and it looks like it is supposed to do >this. What I need is a workaround. > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)