Re: case insensitive matching

Posted in 1994

Takeshi Houjyou — 11 May 1994 03:03:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Sorry, I had to more explain. >From: alan@po.den.mmc.com (Alan Popiel) >Message-Id: <9405101453.AA10299@po.den.mmc.com> >Subject: Re: case insensitive matching >X-Informix-List-Id: <list.3931> > .. stuff deleted .. > >I still would prefer a function like UPPER() for compatibility with other >DBMS's, but if Informix would make the EMATCHES operator available in >non-Japanese versions, it would go a long way toward addressing our needs. > Yes, EMATCHES can use for case insensitive matches in SQL statement, 4GL/ACE/PERFORM expression. Current Japanese version not handle in 4GL CONSTRUCT statement and PERFROM Query operation (always use MATCHES), but modification is not so match difficult. But. Origin purpose of EMATCHES is code insensitive matches. Japanese version Informix must handle ASCII and JIS(JIS X0208 and JIS X0201) code in character field. JIS X0208 have symbole "A" and ASCII code have it. EMATCHES operator match both. So EMATCHES is not only case insensitive operator. I don't know Informix's strategy of internationalization, but I hope if EMATCHES will be adopted, it work case and code insensitive operator. Thanks Takeshi Hojo (take-h@ascii.co.jp)