[OSM-dev] 0.5 API: /api/0.5/user/preferences, values truncated to 256 chars

[Martijn van Oosterhout]

On Tue, Nov 25, 2008 at 8:04 PM, Stefan de Konink <stefan at konink.de> wrote:
>> does monetDB treat strings as byte sequences?
>
> I only know how it works a bit under the surface, basically VARCHAR(255)
> would lets say be a fixed limit of 255 characters. That have an hash
> table over them. So basically every value that is placed in a column is
> an ObjectID pointing to the Hash (IIRC) this implements automatic
> indexing (and deduplication of string values). But I am not a developer
> of the database, only an annoying (yes there too ;) user.

The point is that 255 characters != 255 bytes. Depending on the
encoding it could be up to 1KB. Better check whether your database
understands this.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/