Mysql eror

[GoogleCodeExporter]

hi... i a found a trouble... this eror

Warning at /questions/ask/

Incorrect string value: '\xE5\x88\x9D\xE5\xA7\x8B...' for column 'summary'
at row 1

Request Method:     POST
Request URL:    http://127.0.0.1:8000/questions/ask/
Exception Type:     Warning
Exception Value:    

Incorrect string value: '\xE5\x88\x9D\xE5\xA7\x8B...' for column 'summary'
at row 1

Exception Location:     /usr/lib/python2.5/warnings.py in warn_explicit, line 102
Python Executable:  /usr/bin/python
Python Version:     2.5.2

Original issue reported on code.google.com by Kugutsu....@gmail.com on 12 Jun 2009 at 8:50

[GoogleCodeExporter]

If your database is not in UTF-8 encoding, you need to change to that first.

Original comment by cha...@gmail.com on 13 Jun 2009 at 12:56

[GoogleCodeExporter]

hi.

i add 2 line in my.cf to the mysqld section

default-character-set=utf8
skip-character-set-client-handshake

i add mandarin character in summary. and i find eror [1]

i used cnprog trunk R-0108-20090226

============== [1] =========

Warning at /questions/ask/

Incorrect string value: '\xE5\x88\x9D\xE5\xA7\x8B...' for column 'summary'
at row 1

Request Method:     POST
Request URL:    http://127.0.0.1:8000/questions/ask/
Exception Type:     Warning
Exception Value:    

Incorrect string value: '\xE5\x88\x9D\xE5\xA7\x8B...' for column 'summary'
at row 1

Exception Location:     /usr/lib/python2.5/warnings.py in warn_explicit, line 102
Python Executable:  /usr/bin/python
Python Version:     2.5.2

please help....

many thanks

best regards

Original comment by Kugutsu....@gmail.com on 13 Jun 2009 at 8:43

[GoogleCodeExporter]

SOLVED ..

after restart mysql server

many thanks

regards

Original comment by Kugutsu....@gmail.com on 13 Jun 2009 at 9:02

[GoogleCodeExporter]

Original comment by cha...@gmail.com on 20 Jun 2009 at 4:35

• Changed state: Done