Warning: Incorrect string value: '\xCA\xBCs al...' for column 'name' at row 1

[jaiswalankit]

This is the complete stack trace of the issue, generating while running "python manage.py cities_light" command:

/usr/local/lib/python2.7/dist-packages/autoslug/utils.py:30: RuntimeWarning: Argument <type 'str'> is not an unicode object. Passing an encoded string will likely have unexpected results.
return django_slugify(unidecode(value))

RAM used: 31420 kB Time: 0:00:00 Done: 100%|###################################|
Warning: Incorrect string value: '\xCA\xBCs al...' for column 'name' at row 1

[jpic]

What OS ?

Is there any way I can reproduce this ?

Could you reproduce it in a virtualenv ? I see that you probably ran sudo pip install which is not a good idea because it would install packages globally and potentially mess with python dependencies for system-installed tools.

[ankitjaiswal07]

It's Ubuntu 12.04. You can reproduce is by importing the data into the tables. I can see some characters in the name field of City API which might be causing the char set issue.

[mauricioabreu]

Which database are you using? I suspect it is a problem related to encoding using MySQL.

[jpic]

Did you try with python 3 ?

[jaiswalankit]

No, it was python 2.7.5 and yes, I was using MYSQL database.

On Mon, Dec 29, 2014 at 3:41 PM, James Pic notifications@github.com wrote:

Did you try with python 3 ?

—
Reply to this email directly or view it on GitHub
#62 (comment)
.

[jpic]

Might be fixed by #77

[lluiscanals]

Which CHARACTER SET and COLLATE is your mysql database?

[kodeine]

change your database and its tables to support ut8, it will fix the issue.

[Garfius]

change your database and its tables to support ut8, it will fix the issue.

YES, 4 example:

CREATE DATABASE weblate CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;