Community Learn Tools Library Leisure
search
English
Why does the phpStudy2018 version choose version 5.5.38+Apache or above, and the SQL database is garbled when exported?
IT小谢
IT小谢 2018-09-15 15:04:08
0
1
1435

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小谢

reply all(1)
秋香姐家的小书童
秋香姐家的小书童2018-09-18 16:05:04 1 floor

Incorrect encoding. Do not open it with Notepad

Like +0
Add Reply
  • reply It can't be opened normally with Notepad, and the same error is reported when importing the database. I tried it.
    IT小谢 author 2018-09-19 00:02:49
  • reply 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小谢 author 2018-09-19 00:06:25
  • reply Although copying SQL statements can solve the problem of small databases, if the database runs very slowly, alas
    IT小谢 author 2018-09-19 00:08:36
Popular Topics
More>
Popular Articles
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template