Re: Informix bug???

On Fri, 11 Sep 1998, Florin Micle wrote: >I have a table which contains names on a column. I make a: > SELECT name FROM that_table WHERE name MATCHES '*a*'>The problem is that select returns some not wanted values, that don't >contain a, but contain (!!!) =FC or =F6 or =E4. For example, I made a >select with '*q*', and no name contains q, but I got all the names >which contain =F6,=E4,=FC. >=20 >Any solutions for that? It sounds like a bug, but we need to know a good deal more before deciding. For starters, which version of OnLine or SE are you using? On which platform? Which o/s version? If it is a GLS environment (7.2 or more recent), which locale settings are you using? If it is an NLS environment (6.0 through 7.1x), which locale settings are you using? Can you reproduce the problem using a simple SQL script along the lines of: =09CREATE TEMP TABLE mismatches =09( =09=09... =09); =09INSERT INTO MisMatches VALUES('...'); =09... =09SELECT * FROM MisMatches WHERE ...; If so, post it with the other information requested above. If not, we're left wondering why it is only in a bigger table. Have you run database integrity checks (secheck or oncheck) recently? Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn