Hm... You're right...But I don't understand how it happened... I used sync
db to create those table
mysql> show create table articleManager_categoty\G
*************************** 1. row ***************************
Table: articleManager_categoty
Create Table: CREATE TABLE `articleManager_categoty` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`categoty` varchar(200) NOT NULL,
`name` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql>
can you suggest a command to change charset?
Thanks
On Wed, May 20, 2009 at 4:12 PM, Karen Tracey <[email protected]> wrote:
> 2009/5/20 Oleg Oltar <[email protected]>
>
>> [snip]Strange when I am adding an article with russian text or Section
>> with russian name, everything is OK
>> But when I a trying to add a new category via admin, and use name of it in
>> russian I am getting this exception:
>>
>> Warning at /admin/articleManager/categoty/add/
>>
>> Incorrect string value: '\xD0\xB2\xD0\xB2\xD0\xB2' for column 'name' at row 1
>>
>>
> This means that the character set for your category table (or at least the
> name column within it) is set to something (probably the default latin1)
> that has no representation for the Unicode value specified. To confirm,
> take a look at the output of 'show create table' for your category table in
> a mysql shell. You then need to alter the table so that its character set
> is utf-8. See:
>
> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
>
> You want to use the "convert to character set" option.
>
> Karen
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
