Oliver Zeigermann wrote:
Thought it looks like the same old jdbc-mysql-schema-mistake: BLOBs for uri - but pk(255) .. Silly!
Do not quite understand. What is silly here?
A decition to take BLOB instead of varchar(255) is normally based on using more than 255 chars and a primary key is a unique index. So if insert 2 values which are equal on the first 255 chars you get an error. This means the slide-jdbc-mysql-schema allows uris longer then 255 only if they aren't equal from (0-255) - That's what I meant.
Ooops. Does this mean MySQL allows you to insert values with more than 255 characters, but only truncates all that comes after character 255? Hard to believe...
Oliver
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
