What should I do if the database is normally accessed with PHPMYADMIN but cannot be exported? A database of the school is used to change the platform. To MSSQL, but the data cannot be obtained.
Access using PHPMYADMIN and DBKISS is normal
However, if ACCESS is everywhere, you need to use tools like Navicat. it can be opened with garbled characters.
The format of this column is longtext, which is the introtext shown in the figure.
How can this problem be solved? I have tried changing the encoding format of this column.
The only hope is that the MySQL Export of EMS can be exported, but introtext is displayed as BLOB and cannot be exported.
God, how can we solve this problem? otherwise, I will do it manually.
Please take a look. You can even pay for it ....
If you can help me solve the problem, you can send an email to me, 452188006 QQ.
Thank you!
Reply to discussion (solution)
Are you exporting UTF-8 encoded files?
ACCESS does not support UTF-8. you need to save the file as gbk (ANSI)
Access 2010 supports UTF-8.
Are you exporting UTF-8 encoded files?
ACCESS does not support UTF-8. you need to save the file as gbk (ANSI)
The original code I exported is LIN1.
Access 2010 supports UTF-8.
I don't know, but at least I don't know anyone now.
Are you exporting UTF-8 encoded files?
ACCESS does not support UTF-8. you need to save the file as gbk (ANSI)
The original code I exported is LIN1.
What is your database code?
LATING-1
Thank you for your solution.
Http://hi.baidu.com/liuhao8640/item/2bdf87d008b34a19d78ed0b0