数据库用PHPMYADMIN访问正常却无法导出怎么办？-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

数据库用PHPMYADMIN访问正常却无法导出怎么办？

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 02:21 PM

学校的一个数据库，拿下来打算换平台。到MSSQL上去，但是数据弄不下来。
用PHPMYADMIN访问和DBKISS访问都正常

但是要到处到ACCESS的话需要用Navicat这样的工具，可以打开之后全是乱码。

这个列的格式是longtext 就是图中看的introtext.

这个问题如何解决？更换这一列的编码格式什么的都试过了。
唯一有点希望的是EMS的MySQL Export，能导出，但是其中introtext显示为BLOB,无法导出。

神啊，要如何解决啊，不然我要手工弄了。
求求大神，帮我看看。哪怕花点费用也可以啊。。。。
如果您能帮我解决可以发邮件我，452188006 QQ的。
多谢了啊

回复讨论(解决方案)

你导出的是 utf-8 编码的文件吧？
ACCESS 并不支持 utf-8，你需要将文件另存为 gbk的（ANSI）

Access 2010是支持UTF-8了的吧。

你导出的是 utf-8 编码的文件吧？
ACCESS 并不支持 utf-8，你需要将文件另存为 gbk的（ANSI）

我导出的原始编码是LIN1.

Access 2010是支持UTF-8了的吧。
不知道但是最起码现在到出去的不认识

你导出的是 utf-8 编码的文件吧？
ACCESS 并不支持 utf-8，你需要将文件另存为 gbk的（ANSI）

我导出的原始编码是LIN1.

你数据库编码是什么？

LATING-1

谢谢大家顺利解决了。

http://hi.baidu.com/liuhao8640/item/2bdf87d008b34a19d78ed0b0

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Working with Flash Session Data in LaravelMar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

cURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

Simplified HTTP Response Mocking in Laravel TestsMar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

12 Best PHP Chat Scripts on CodeCanyonMar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Explain the concept of late static binding in PHP.Mar 21, 2025 pm 01:33 PM

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

PHP Logging: Best Practices for PHP Log AnalysisMar 10, 2025 pm 02:32 PM

PHP logging is essential for monitoring and debugging web applications, as well as capturing critical events, errors, and runtime behavior. It provides valuable insights into system performance, helps identify issues, and supports faster troubleshoot

HTTP Method Verification in LaravelMar 05, 2025 pm 04:14 PM

Laravel simplifies HTTP verb handling in incoming requests, streamlining diverse operation management within your applications. The method() and isMethod() methods efficiently identify and validate request types. This feature is crucial for building

Discover File Downloads in Laravel with Storage::downloadMar 06, 2025 am 02:22 AM

The Storage::download method of the Laravel framework provides a concise API for safely handling file downloads while managing abstractions of file storage. Here is an example of using Storage::download() in the example controller:

See all articles