Home>

on windows when you create the database in the console, it automatically has anSi format, how to recover, or immediately save to UTF-8? I tried to open as a notebook and save there in UTF-8, but then stops working.

  • Answer # 1

    Create database:

    Create Database `dbName` CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;
    

    To transfer Django data, use and Loaddata.

    And if it is created in ANSI already in UTF8 not to convert?

    arcs_host2021-06-15 13:01:56

    Translate your comment on Russian (with finely income). It is not necessary to translate from ANSI to UTF8, ANSI characters are a subset of UTF8. Another thing is that an ANSI symbols are something else on a petty language. Some 8-bit encoding (CP1251?), Containing ANSI and something else.

    alexlz2021-06-15 13:01:56
  • Answer # 2

    Create database:

    Create Database `dbName` CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;
    

    To transfer Django data, use and Loaddata.

    And if it is created in ANSI already in UTF8 not to convert?

    arcs_host2021-06-15 13:01:56

    Translate your comment on Russian (with finely income). It is not necessary to translate from ANSI to UTF8, ANSI characters are a subset of UTF8. Another thing is that an ANSI symbols are something else on a petty language. Some 8-bit encoding (CP1251?), Containing ANSI and something else.

    alexlz2021-06-15 13:01:56