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

[Normand Savard]

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?
> 
>Jason
> 
>________________________________
>
>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.
>
>  
>
All,

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)?

Thanks.

Norm