[mapserver-users] Problem with search using msQueryByAttributes

[Roman Meier]

Hi list

One of my customers is facing a very strange problem. I spent quite some
time trying to figure out where the problem is coming from, but now I'm
giving up.

The problem appears with php/mapscript v4.0.2. There are no plans right
now to upgrade to a newer version. I use the msQueryByAttributes
function to search for records. It's a bit strange and definitely a
mistery to me:

If I search for a string ending with "UF" or "uf", f.e. "525UF", I get
the following message: Warning: [MapServer Error]:
msQueryByAttributes(): No matching record(s) found. in [...]. The entry
"525UF" is definitely there!

If I search for the string "4028UF", msQueryByAttributes returns the
entry "4028". Same thing is I search for the string "4028uf".

Just for more complete info: Entries ending with different caracters,
f.e. "4023A" are found. Is this not strange?

Any ideas?

Kind regards,
Roman