[mapguide-users] Shapefile Query don't return all results

Normand Savard nsavard at mapgears.com
Wed May 2 11:26:34 EDT 2007

Jason Birch wrote:

>Hi Normand,
>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 
expected results. 

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 mailing list