0

I am creating a simple django application and I want to know how can I store and show japanese characters in this application? I'm creating the models in my django app and then this question pop up in my head.

  • Django tends to save things in unicode, so you [should be fine](http://stackoverflow.com/questions/19899554/unicode-range-for-japanese) – NightShadeQueen Jul 23 '15 at 04:42

1 Answers1

0

Doing an ALTER to charset utf8 solved the issue:

For Example

ALTER TABLE title MODIFY 
    column VARCHAR (100)
    CHARACTER SET utf8
    COLLATE utf8_unicode_ci;

Another Way is cur.execute("set names utf8;") add before query execution

cur = con.cursor()

cur.execute("set names utf8;")     # <--- add this line,
Bhavin Solanki
  • 4,740
  • 3
  • 26
  • 46