[TinyOWS-users] Encoding problems with WFS attribute values

[Gissur Þórhallsson]

The database I'm working against returns the following:
Encoding:  UTF8
Collation: en_US.UTF-8
Ctype:     en_US.UTF-8

Maybe that en_US prefix is what's giving me problems, though I've been using
that collation/CType for over two years now against geoserver and php with
little problem.

A request to tinyOWS gives the following from the log:
<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
version="1.0.0" outputFormat="application/json"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd
http://www.redacted.url/
http://www.redacted.url/cgi-bin/tinyows?service=wfs&amp;request=DescribeFeatureType&amp;version=1.1.0&amp;typename=postgis:raektunarspildur<http://www.redacted.url/cgi-bin/tinyows?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=postgis:raektunarspildur>
"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Query typeName="feature:raektunarspildur" xmlns:feature="
http://www.redacted.url/">
 <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:BBOX>
 <ogc:PropertyName>
the_geom
</ogc:PropertyName>
 <gml:Box xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:3057">
<gml:coordinates decimal="." cs="," ts=" ">
 375814.67365644,573990.42956723 378933.22752796,576477.51155755
</gml:coordinates>
 </gml:Box>
</ogc:BBOX>
</ogc:Filter>
 </wfs:Query>
</wfs:GetFeature>

Kind regards from Iceland,
Gissur

On Thu, Sep 9, 2010 at 4:30 PM, Olivier Courtin
<olivier.courtin at gmail.com>wrote:

>
> On Sep 9, 2010, at 5:34 PM, Gissur Þórhallsson wrote:
>
> Hi Gissur,
>
> > I have tinyOWS up and running (under Apache running on ubuntu 8.0.4
> > LTS) against
> > OpenLayers and it works fine geometry-wise, but when it comes to
> > attribute values
> > containing non-standard characters those characters get all garbled,
> > while it all looks
> > okay on the postgis side.
>
>
> I'm not that sure to fully understand yet where you problem occur,
>
> Could you activate the tinyows log and send here the content of the log
> related to your problematic query
>
> Could you also indicate in which encoding your postgresql datase are
> (with psql -l command)
>
> Tks,
>
>
> > The response from tinyOWS states that it's using UTF-8, but I wanted
> > to experiment and
> > force it to return iso-8859-1 for instance, but I can't figure out
> > how to make it do that - am
> > I missing something frightfully obvious?
>
> Right now there's no such a feature as UTF-8 is supposed to be a
> correct answer
> for everyone in the world... :)
>
> --
> Olivier
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users
>



-- 
Gissur Þórhallsson

Loftmyndir ehf.
Laugavegur 13
IS 101 Reykjavík - Iceland
sími (tel): (+354) 540 2500
tölvupóstur (email): gissur at loftmyndir.is
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20100910/aa950f1d/attachment.htm