I have a little problem. My data base is a mysql ENGINE=MyISAM
CHARSET=utf8. I'm using Django revision: 6411
mysql> select id,name from core_category;
+----+----------------------+
| id | name |
+----+----------------------+
| 1 | a�os ha que no te v� |
| 2 | ámigo que onda!!! |
| 3 | La lúna!!! |
+----+----------------------+
3 rows in set (0.04 sec)
The first value was insert by the django admin console and is is
latin1, The bd see it wrong.
The second value was insert by a simple direct insert in the bd.
And the third was insert by the django shell (python manage.py shell)
encoding in utf8 and is OK!!!
See it yourself:
>>> a=pymy.connect(host='localhost', db='test',user='sabri',passwd='sabri')
>>> c=a.cursor()
>>> c.execute('select id,name from core_category')
>>> d=c.fetchall()
>>> d
((1L, 'a\xf1os ha que no te v\xed'), (2L, '\xc3\xa1migo que onda!!!'),
(3L, 'La l\xc3\xbana!!!'))
>>> name=d[0][1]
>>> name.decode('utf8')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "encodings/utf_8.py", line 16, in decode
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 1-4:
invalid data
>>> print name.decode('latin1')
años ha que no te ví
>>> name2=d[1][1]
>>> print name2.decode('utf8')
ámigo que onda!!!
>>> name2=d[2][1]
>>> print name2.decode('utf8')
La lúna!!!
When i see my data through the django admin console the only one which
i see ok is the first one. See it:
años ha que no te ví
La lúna!!!
ámigo que onda!!!
Thing is than django takes data as latin1 and save it in that
encoding. When show it, (my utf8 encoding data) do it in a bizarre
way, because interpret it in latin1.
Why do this? how can i configure it?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
