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

Normand Savard nsavard at mapgears.com
Thu May 3 09:04:24 EDT 2007


Normand Savard wrote:

> 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
>
Does someone have an answer to these questions or do I need to add some 
clarifications to what I mean?

Norm


More information about the mapguide-users mailing list