Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

On Sun, Oct 12, 2008 at 9:56 AM, felix <[EMAIL PROTECTED]> wrote: > but what does the unittest runner do ?? (since it creates its own > database) > > it also creates a latin1 db: > > CREATE TABLE `website_releasefeedback` ( > ... > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > Use this setting: http:

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

thanks too for this. rather than alter the table manually of course, it should have been created correctly the first time. mysql will create new tables with the character encoding of the database. you can set that this way: alter database cruxxial_md CHARACTER SET = utf8; now tables created

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

Thanks for the suggestion :) --~--~-~--~~~---~--~~ 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 [EMAI

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

On 6 Oct 2008, at 10:14 am, tamonash wrote: > mysql> show create table ac_project_messages; > +- > +- > -- > -

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

Thanks Malcolm, You solved my problem. These tables were something that I was using from a previous application so all the mess.. As suggested by you, this is what I did. mysql> show create table ac_project_messages; +- +---

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

Set collation to utf-8 I had the same problem with Russian until i change collation for all char field in my DB to utf-8 and default collation for DB --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" gr

Re: Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

On Mon, 2008-10-06 at 00:29 -0700, tamonash wrote: > I am using webfactional for hosting my site. I created my database > from the control panel with utf8 as the encoding. I want my > application to be able to use other characters than English like > Japanese etc.. This is one of my models: [...

Why does MySql gives warning? Incorrect string value: '\xE6\x9D\xB1\xE8\xA8\xBC...' for column 'title' at row 1

I am using webfactional for hosting my site. I created my database from the control panel with utf8 as the encoding. I want my application to be able to use other characters than English like Japanese etc.. This is one of my models: class AcProjectMessages(models.Model): milestone_id = models