Hi Anshum,
At first I modified the db charset with below commands. It did not help.
ALTER DATABASE mybooks DEFAULT CHARACTER SET = 'utf8' DEFAULT COLLATE =
'utf8_general_ci'
ALTER TABLE book DEFAULT CHARACTER SET = 'utf8' COLLATE =
'utf8_general_ci'
It worked after I tried this
ALTER TABLE book *CONVERT TO CHARACTER SET* 'utf8' *COLLATE *
'utf8_general_ci'
On Sat, Apr 13, 2013 at 9:07 PM, Anshum Verma <[email protected]>wrote:
> This seems to be coming from MySQL . Can you check what is the default
> charset for the Book table in mysql and also that of the individual
> columns. You can share the output of show create table from mysql.
>
> Regards,
> Anshum
>
>
> Sent from my Windows Phone
> ------------------------------
> From: mln sastry <[email protected]>
> Sent: 13-04-2013 11:07
> To: Anshum Verma <[email protected]>
> Cc: [email protected]
> Subject: Re: Unable to storing unicode data using django
>
>
>
> Hi Anshum,
> Thank you for responding.
> I defined a Book model as shown below and tried to save it from the
> admin shell.
> I am using python2.7.3 , django1.5, and python mysql driver 1.2.3.
> I am not sure if my model data type is wrong or if any qualifier is
> missing. Please help.
>
> I got this error:Warning: Incorrect string value:
> '\xE0\xA4\xB6\xE0\xA5\x8D...' for column 'bookName' at row 1"
>
> class *Book*(models.Model):
>
> bookId = models.AutoField(primary_key=True)
>
> bookName = models.TextField(max_length=200,null=False,)
>
> bookShortName = models.CharField(max_length=10,null=True,)
>
> isDeleted = models.NullBooleanField (null=True,)
>
>
>
> gita4 = Book(bookName= "श्रीमद्भगवद्गीता",bookShortName="गीता"
> ,isDeleted=False)
>
> gita4.save()
>
> Traceback (most recent call last):
>
> File "<console>", line 1, in <module>
>
> File "C:\py\lib\site-packages\django\db\models\base.py", line 546, in
> save
>
> force_update=force_update, update_fields=update_fields)
>
> File "C:\py\lib\site-packages\django\db\models\base.py", line 650, in
> save_base
>
> result = manager._insert([self], fields=fields, return_id=update_pk,
> using=using, raw=raw)
>
> File "C:\py\lib\site-packages\django\db\models\manager.py", line 215, in
> _insert
>
> return insert_query(self.model, objs, fields, **kwargs)
>
> File "C:\py\lib\site-packages\django\db\models\query.py", line 1661, in
> insert_query
>
> return query.get_compiler(using=using).execute_sql(return_id)
>
> File "C:\py\lib\site-packages\django\db\models\sql\compiler.py", line
> 937, in execute_sql
>
> cursor.execute(sql, params)
>
> File "C:\py\lib\site-packages\django\db\backends\util.py", line 41, in
> execute
>
> return self.cursor.execute(sql, params)
>
> File "C:\py\lib\site-packages\django\db\backends\mysql\base.py", line
> 120, in execute
>
> return self.cursor.execute(query, args)
>
> File "C:\py\lib\site-packages\MySQLdb\cursors.py", line 204, in execute
>
> if not self._defer_warnings: self._warning_check()
>
> File "C:\py\lib\site-packages\MySQLdb\cursors.py", line 117, in
> _warning_check
>
> warn(w[-1], self.Warning, 3)
>
> Warning: Incorrect string value: '\xE0\xA4\xB6\xE0\xA5\x8D...' for column
> 'bookName' at row 1
>
>
> On Fri, Apr 12, 2013 at 9:26 PM, Anshum Verma <[email protected]>wrote:
>
>> Utf8 is default support in django unless you are explicitly typecasting
>> to str. Please provide details of traceback and code snippets to debug this.
>>
>>
>> Sent from my Windows Phone
>> ------------------------------
>> From: sastry mln <[email protected]>
>> Sent: 12-04-2013 17:29
>> To: [email protected]
>> Subject: Unable to storing unicode data using django
>>
>> Hi All,
>> I have a mysqldb with utf8 charset and utf8_general_ci collation. The
>> tables are also explicity defined to use the same charset/collation
>> I have a django model with CharField.
>> I want to store unicode characters (hindi language chars)
>> when i tested the model form django admin shell, I got error saying
>> that the character is unrecognised.
>>
>> I read the unicode section of the documenation, but i did not
>> understand clearly.
>>
>> can someone please post a snippet about how to let the web application
>> allow unicode data entry using (A) from django shell (b) From the data
>> entry screen created through the modelAdmin forms
>>
>> regards
>> mln
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/django-users?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
