[OSM-dev] UTF-8 problems in informationfreeway?

[Stefan Baebler]

welcome back!

In the meantime I imported the extract of slovenia into mysql and it 
looks perfect.

windoze box, osmosis 0.24, java 6, mysql 5.0.18-nt-max (with default 
character set utf8!)
data flow: planet.osm->osmosis extract->slovenia.osm->osmosis import ->mysql

It is likely the db config on informationfreway, some locale,  some 
incompatible mysql driver...
Attaching my.ini

greets,
Stefan

Brett Henderson wrote:
> It warms my heart to return from leave to discover new osmosis utf8 
> problems, I missed those little guys ;-)
>
> I'll check it out.  Might take me a few days though because I'm a bit 
> overwhelmed with email and Christmas at the moment ...  Strictly 
> speaking I suspect this is not truly a bug but yet another artefact of 
> the database encoding issues, it may not be easy to nail.
>
> Stefan Baebler wrote:
>   
>> Another artifact of similar utf problem can be seen at yesterday's
>> lowzoom(!) tile:
>> http://tah.openstreetmap.org/Tiles/info.php?x=1107&y=727&z=11&layer=tile
>> Mengeš ("š" is ok)
>> Domžale ("ž" is ok)
>> Moravče ("č" turned into "Ä ")
>>
>> On zoom 12 and higher "č" in Moravče is ok:
>> http://tah.openstreetmap.org/Tiles/info.php?x=4431&y=2909&z=13&layer=tile
>>
>> There definitely is a problem _somewhere_.
>>
>> In today's and last week's dump node is ok (extract made with osmosis!):
>>   <node id="29161753" timestamp="2007-12-02T08:52:13Z"
>> lat="46.1356895" lon="14.7445634">
>>     <tag k="created_by" v="JOSM"/>
>>     <tag k="name" v="Moravče"/>
>>     <tag k="place" v="town"/>
>>   </node>
>> (this xml snippet is an extract of a planet file, done with osmosis
>> for local archive: http://osm.baebler.net/data/ )
>>
>> Osmosis seems to handle that in files(!) just fine, but osmxapi gives it wrong:
>>
>> http://www.informationfreeway.org/api/0.5/node%5bplace=town%5d%5bbbox=14.5,46.1,14.8,46.2%5d
>> either there is a bug in osmxapi or during the import into its db.
>>
>> hope it helps tracking it down.
>>
>> greets,
>> Štefan
>>
>> On Dec 8, 2007 12:54 AM, Frederik Ramm <frederik at remote.org> wrote:
>>   
>>     
>>> Hi,
>>>
>>>     
>>>       
>>>> This appears to be an osmosis problem.
>>>> A recent planet contains the following:
>>>>       
>>>>         
>>> [...]
>>>
>>> I concur; the latest daily diff before the Dec06 planet file had UTF-8
>>> problems as well but the affected objects were represented ok in the
>>> planet file.
>>>
>>> Bye
>>> Frederik
>>>
>>> _______________________________________________
>>>
>>> dev mailing list
>>> dev at openstreetmap.org
>>> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>>>
>>>     
>>>       
>> _______________________________________________
>> dev mailing list
>> dev at openstreetmap.org
>> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>>   
>>     
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>   

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: my.ini
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20071217/9bd9f4bb/attachment.ksh>