Re: Basic question: ignoring case

}From: onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") }Date: Mon, 7 Oct 1996 12:04:16 GMT }X-Informix-List-Id: <news.28958> } }Nils keeps saying that case insensitive queries will be in Universal }Server. But will they be available in ISQL, I4GL at that time? And will }they be available with no database and/or application changes? }> panic@suba.com () wrote: }> :I'm just starting with Informix SQL, and I was wondering how to do a }> case :insensitive query (the tutorial doesn't cover it, and Borders is }> out of the :reference manual). }> }> Check the FAQ. It has solutions, although no good ones. They will only }> be available in Universal Server due out in December this year (for }> some platforms, later for others). }> }> Nils.Myklebust@idg.no If the necessary functions are built into the engine, they will be available to ISQL and I4GL because they will look like ordinary SPL or built-in functions. The ISQL and I4GL languages do not have any record of the functions built into the engines, so they will simply pass the statements through to the engine, where the case-insensitive operations will occur. Of course, you won't be able to do the same query in I4GL at the application side because the functions won't be part of the I4GL support libraries. As far as I know, no database changes are necessary. The application will have to be changed to use the new functions, of course. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>