[OSM-dev] api0.6 - only one value per key?

Shaun McDonald shaun at shaunmcdonald.me.uk
Fri Jan 30 15:46:57 GMT 2009


On 30 Jan 2009, at 15:11, Andreas Kalsch wrote:

>
>
>
> Question: I have found a PGSQL schema for v0.6 where key and value are
> TEXT fields. Is the length of 255 still correct for v0.6?

Are you sure it is the rails schema, there are other gpsql database  
schemas for osm data out there, which aren't related to the rails/ 
master db setup.

>
> There are some imported values which are longer than 255 characters.
>

Strictly speaking at the moment it is 255 latin characters, which can  
is different to 255 UTF-8 multi-byte characters, hence the problem at  
the moment of large UTF-8 multibyte strings being truncated and  
causing invalid UTF-8 errors.

Shaun





More information about the dev mailing list