Django & MySQL unicode errors

Question

I am getting an Incorrect string value (Exception Value: Incorrect string value: '\xEA\xB0\x95\xED\x95\x98...' for column 'object_repr' at row 1) error while trying to save unicode string (Korean) in Django and MySQL.First problem I had was "Incorrect string value" error for each column in the database table. However, I figured this out by changing column collation and overall database character set.

The new error I am getting is related to unicode(self) method in models.py.My models.py is as the following:

from django.db import models

# Create your models here.
class User(models.Model):
full_name = models.CharField(max_length=60)
email = models.EmailField(unique=True)
password = models.CharField(max_length=128)
birthday = models.DateField(null=True, blank=True)
gender = models.PositiveIntegerField(null=True, blank=True)
location = models.CharField(max_length=60, null=True, blank=True)
captcha = models.CharField(max_length=60, null=True, blank=True)

register_date = models.DateTimeField()
lastLogin_date = models.DateTimeField(null=True)
num_logins = models.PositiveIntegerField()

def __unicode__(self):
    return self.full_name

The error is generated when the__unicode__ function tries to output utf8 character...

Does anybody know how to fix this error?

Have you tried applying the smart_unicode utility to self.full_name (docs.djangoproject.com/en/dev/ref/unicode/#conversion-functions) ? — jdi
– jdi, Commented Jul 16, 2012 at 5:34

Vladimir Vlasov · Accepted Answer · 2012-08-01 19:29:23Z

10

In MySQL console execute

ALTER DATABASE django_db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE django_admin_log MODIFY object_repr VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;

For me it helps.

answered Aug 1, 2012 at 19:29

Vladimir Vlasov

2,1103 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fastmultiplication Over a year ago

for making adminsite accept unicode - confirmed to work in django 4.0.4. This is required even after changing table and db charset. Note in my case it varied slightly: ALTER TABLE django_admin_log MODIFY object_repr VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

Wouter Dorgelo · Accepted Answer · 2012-07-16 13:38:33Z

-1

Try add one line on the first of this file like this:

#-*- encoding=UTF-8 -*-

edited Jul 16, 2012 at 13:38

Wouter Dorgelo

12.1k12 gold badges67 silver badges80 bronze badges

answered Jul 16, 2012 at 9:57

fuyunbiyi

382 bronze badges

Comments

rayryeng · Accepted Answer · 2014-06-29 04:49:20Z

-1

I solved this problem by changing the file settings.py: Don´t use 'ENGINE': 'django.db.backends.mysql'.

edited Jun 29, 2014 at 4:49

rayryeng

105k22 gold badges201 silver badges206 bronze badges

answered Jun 29, 2014 at 4:23

user3787102

7

Collectives™ on Stack Overflow

Django & MySQL unicode errors

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related