What should I do if the database is normally accessed with PHPMYADMIN but cannot be exported?

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.