> The point is that utf8 can use up to 3 bytes per character...
i appreciate your reply. interesting distinction between bytes and
chars. i think i still need some more guidance. still not sure how to
resolve with your suggestion to consdier the character set.
i am able to create the django model class defining the table manually
in mysql without any error. i was also able to create that same model
with django 1.0.2 using syncdb. however, with django 1.1.1 i get the
max_length error (as originally posted). it seems like the django
syncdb code is detecting a size threshold, outputting the error, and
exiting without ever really attempting the mysql table create.
here's the mysql table created by django 1.0.2 syncdb without any
errors (some portions redacted) as output with 'show create table t':
CREATE TABLE `t` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(760) NOT NULL,
...
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
...
) ENGINE=InnoDB AUTO_INCREMENT=1374 DEFAULT CHARSET=latin1
and here it is as i manually created it in mysql:
REATE TABLE `mbg_t` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(760) NOT NULL,
...
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
the corresponding model class in models.py has not changed from django
1.0.2 to 1.1.1:
url = models.CharField('Full URL', max_length=760, unique=True)
when we first implemented this a year ago for django 1.0.2 we tried
using a TextField; however, we switched to CharField due to
http://code.djangoproject.com/ticket/2495 which still seems
unresolved.
just looking for a simple way to specify a url field in models.py that
will allow creation with django 1.1.1 syncdb and mysql 5.0.67. want
this url text/char field to be as large as permitted and unique.
thanks all for your time and assistance!
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
