[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