On Thu, Aug 6, 2009 at 7:32 PM, Andreas Schildbach<[email protected]> wrote: > On Thu, 2009-08-06 at 15:04 +1200, Brenda Wallace wrote: > >> on the table "file" the column "url" is a varchar(255) >> >> for postgres, I can change this column to a type "text", and it's solved. >> i understand mysql is really slow at handling "text" columns, so i'm >> unsure if we can do the same there. > > Mysql 5.0.3 and above allows for up to VARCHAR(65535). > > http://dev.mysql.com/doc/refman/5.0/en/char.html
So how would we like to handle mysql? I don't know enough about scaling a mysql database to make this call. I have a commit to make this work in postgresql again - I'll push this on it's own if we just want to leave mysql truncating. The url that triggered this is someone giving an example of XSS - hence the url was very long to include all the javascript to be injected. I reckon this is a valid use of laconica as a communications platform, so I definitely want very very long urls to work for mysql users too. _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
