[mapguide-users] Shapefile Query don't return all results
nsavard at mapgears.com
Wed May 2 11:26:34 EDT 2007
Jason Birch wrote:
>Is it possible that this is an encoding issue? For instance, are there any French characters in the DBF file? Or maybe there are embedded spaces in the street or city name?
>From: Normand Savard
>Subject: [mapguide-users] Shapefile Query don't return all results
>I also tested with the following query "(MUNICIPALI LIKE
>'$szMunicipality') AND (NOM LIKE '$szStreet') " and it returns only one
>result but it should return two results.
I made a mistake when I verified the data. The number of results when I
set $szMunicipality = "Mandeville" and
$szStreet = "Bergeron" is correct. So the query results match the
There is still a question though related to the same query since some of
the data contains French accents. I verified that the shape attributes
in the source DBF file are in ISO-8859-1 encoded. I imported the
Shapefile via MapGuide Web Studio. I'm doing a GetString() from the
featureReader and the output of this method is UTF-8 encoded. Is it
MapGuide or FDO that changes the data encoding? Is it possible to keep
the original data encoding? How can we configure/manage the encoding to
be used by MapGuide to output the data? Which encoding should I use for
the accents in my filter (ISO-8859-1 or UTF-8)?
More information about the mapguide-users