[TinyOWS-users] Encoding problems with WFS attribute values

[Gissur Þórhallsson]

Hi,

I managed to resolve this issue by recreating my database with the locale
set to is_IS.UTF-8 (Icelandic, the native locale for the data) -

I can imagine though, that it still might be useful to be able to set
the PG_CLIENT_ENCODING
through tinyOWS before querying postgis, since dumping a database and
recreating it in a different locale is anything but trivial if you have a
large database.

I just got lucky that I only need tinyOWS for a small subset of my data -
which I had already put into its own database beforehand.

But thanks anyway and best regards from Reykjavík,
Gissur Þórhallsson

2010/9/10 Gissur Þórhallsson <gissur at loftmyndir.is>

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



-- 
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/d531d84d/attachment.htm