Re: django unicode error

2008-11-17 Thread jamesM
Karen, thank You su much for the help! after executing "show create table' i realised there was a problem in my character_set+collation, changed it from latin1_swedish_ci (can't remember which charset it was)to utf8+utf8_general_ci, and now everything works like a charm. Thanks once again! all

Re: django unicode error

2008-11-16 Thread Karen Tracey
On Sun, Nov 16, 2008 at 10:18 AM, jamesM <[EMAIL PROTECTED]>wrote: > > there is a value 'Qué Onda Guero' in a mysql database. When i SELECT > this row from mysql, it's displayed correctly. When i connect to mysql > DB through python 2.6 shell using mySQLObject and assign the value to > a list, the

django unicode error

2008-11-16 Thread jamesM
there is a value 'Qué Onda Guero' in a mysql database. When i SELECT this row from mysql, it's displayed correctly. When i connect to mysql DB through python 2.6 shell using mySQLObject and assign the value to a list, the >>list_name[0] gives 'Qu\xc3\xa9 Onda Guero', and >>variable =list_name[0]