> Oliver Zeigermann wrote: > > 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... >
Not true: If a value is unique on the first 255, you don't get any error and it works fine. But if it equals an existing value, the whole insert stops. So, if you like to have uri(255+) you got to switch to normal key .. This index is not unique. (That is what I did with jdbc-store.) But if this doesn't matter, because anyone uses uris between 0-255, then why blob, simply choice varchar(255). - And this is what you got now. OK for me. regards, alex. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
