Django往mysql存数据Out of range value for column 'size' at row 1-优快云博客

本文探讨了在使用 Django 的 Model 中的 IntegerField 时遇到的超出范围错误，具体表现为当尝试存储大于 2147483647 的整数时，会触发 DataError。文章深入分析了 Django 的 IntegerField 实现，并指出其最大值限制为 2147483647，解释了错误产生的原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码：

class VideoSource(models.Model):
    classification = models.ForeignKey(Classification, null=True, on_delete=models.SET_NULL)
    create_time = models.DateTimeField(auto_now_add=True)
    update_time = models.DateTimeField(auto_now_add=True)
    title = models.TextField(default="")
    describe = models.TextField(default="")
    url = models.CharField(max_length=255, db_index=True)
    key_name = models.CharField(max_length=255)
    covers = models.TextField(default="{}")
    size = models.IntegerField(default=0)

当我存size是3017072127这么大的时候就会报 DataError: (1264, "Out of range value for column 'size' at row 1")

查看源码发现

class IntegerField(Field):
    empty_strings_allowed = False
    default_error_messages = {
        'invalid': _("'%(value)s' value must be an integer."),
    }
    description = _("Integer")

    def check(self, **kwargs):
        errors = super(IntegerField, self).check(**kwargs)
        errors.extend(self._check_max_length_warning())
        return errors

    def _check_max_length_warning(self):
        if self.max_length is not None:
            return [
                checks.Warning(
                    "'max_length' is ignored when used with IntegerField",
                    hint="Remove 'max_length' from field",
                    obj=self,
                    id='fields.W122',
                )
            ]
        return []

    @cached_property
    def validators(self):
        # These validators can't be added at field initialization time since
        # they're based on values retrieved from `connection`.
        range_validators = []
        internal_type = self.get_internal_type()
        min_value, max_value = connection.ops.integer_field_range(internal_type)
        if min_value is not None:
            range_validators.append(validators.MinValueValidator(min_value))
        if max_value is not None:
            range_validators.append(validators.MaxValueValidator(max_value))
        return super(IntegerField, self).validators + range_validators

class BaseDatabaseOperations(object):
    """
    This class encapsulates all backend-specific differences, such as the way
    a backend performs ordering or calculates the ID of a recently-inserted
    row.
    """
    compiler_module = "django.db.models.sql.compiler"

    # Integer field safe ranges by `internal_type` as documented
    # in docs/ref/models/fields.txt.
    integer_field_ranges = {
        'SmallIntegerField': (-32768, 32767),
        'IntegerField': (-2147483648, 2147483647),
        'BigIntegerField': (-9223372036854775808, 9223372036854775807),
        'PositiveSmallIntegerField': (0, 32767),
        'PositiveIntegerField': (0, 2147483647),
    }