Oleg Broytmann escribió: > On Thu, Nov 08, 2007 at 03:22:20PM +0000, jonhattan wrote: > >> sqlobject.dberrors.OperationalError: BLOB/TEXT column 'nombre' used in >> key specification without a key length >> >> It fixs adding length to the params. >> >> In postgres it does not complain. >> > > Without looking into the MySQL and Postgres docs I guess MySQL doesn't > allow TEXT columns to be unique (alternateId implies uniqueness). > If it's so there is not much SQLObject can do about this. > > Oleg. > I found the problem is that mysql does not support keys more than 1000 bytes[1]. A workaround could be to set a length of 1000 if no length is specified and alternateId is present. 1000 for StringCol, 333 for UnicodeCol (1000 bytes / 3 bytes * char)
http://bugs.mysql.com/bug.php?id=4541 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
