search

Home  >  Q&A  >  body text

Why does the phpStudy2018 version choose version 5.5.38+Apache or above, and the SQL database is garbled when exported?

If you choose version 5.5.38 or above, the SQL database files exported using PHPMYADMIN management will be garbled. If you use versions below this version, there will be no garbled characters? I am using the UTF-8 character set. When will PHPSTUDY solve this BUG? QQ图片20180915150312.png

2.png

IT小谢IT小谢2305 days ago1450

reply all(1)I'll reply

  • 秋香姐家的小书童

    秋香姐家的小书童2018-09-18 16:05:04

    Incorrect encoding. Do not open it with Notepad

    reply
    0
    • IT小谢

    It can't be opened normally with Notepad, and the same error is reported when importing the database. I tried it.

    — IT小谢 · 2018-09-19 00:02:49
    IT小谢

    At present, I can only select the SQL statement when exporting, and then copy and save it as a Notepad file, so that garbled characters will not appear. If the default compressed file or other methods of storing database files will appear, garbled characters will appear. It seems that PHP5.5 version and PHPmyadmin have bugs.

    — IT小谢 · 2018-09-19 00:06:25
    IT小谢

    Although copying SQL statements can solve the problem of small databases, if the database runs very slowly, alas

    — IT小谢 · 2018-09-19 00:08:36
  • Cancelreply