id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
13919	"""Incorrect string value"" warning when saving some unicode characters to MySQL"	Denilson Figueiredo de Sá	nobody	"How to reproduce this bug, step-by-step:

1. Create a new project.

2. Create the database for this project in MySQL. Make sure the database has 'utf8' as its collation.

3. Create a new app inside your project (here I'm calling it 'testapp'). Remember to add it to settings.py.

4. At the models, create a simple one (I've named it TestModel) with just a CharField and/or a TextField.

5. ./manage.py syncdb

6. ./manage.py shell

7. from testapp.models import TestModel

8. Create a new instance of your model and set its attribute to u""Su\u1296it\U000f2a61\r\n""

9. Call .save()

Boom! MySQLdb throws:
{{{
Warning: Incorrect string value: '\xF3\xB2\xA9\xA1\x0D\x0A' for column 'cf' at row 1
}}}

Please note that other unicode strings (like u'Bh\u0101skara\n') do work correctly, thus the MySQL database was set up correctly. However, that string above makes MySQLdb throw an exception.

Does the string above make any sense? I don't know, it was a piece of text copied-and-pasted by the user.

Versions:

* Django 1.1.2
* MySQL 5.0.90
* mysql-python (MySQLdb) 1.2.3_rc1
* Python 2.6.5
"	Uncategorized	closed	Uncategorized	1.2	Normal	invalid			Unreviewed	0	0	0	0	0	0