What should I do if the database is accessed normally with phpMyAdmin but cannot be exported?
School of a database, take down to change the platform. Go to MSSQL, but the data can't get down.
Access and Dbkiss access are normal with phpMyAdmin
But to go everywhere to access words need to use navicat such tools, can open after all is garbled.
The format of this column is Longtext is the introtext in the picture.
How to solve this problem? I've tried to change the encoding format for this column.
The only hope is that the EMS MySQL export, can be exported, but where Introtext is displayed as a blob, cannot be exported.
God, how to solve Ah, or I will do it by hand.
Ask the great God to help me see. Even if you spend a bit of money can ah ....
If you can help me solve can send e-mail me, 452188006 QQ.
Thanks, man.
Share to:
------Solution--------------------
You're exporting a utf-8 encoded file, right?
ACCESS does not support utf-8, you need to save the file as GBK (ANSI)
------Solution--------------------
Access 2010 is supported by UTF-8.
------Solution--------------------
References:
Quote: References:
You're exporting a utf-8 encoded file, right?
ACCESS does not support utf-8, you need to save the file as GBK (ANSI)
The original encoding I exported is LIN1.
What is your database code?
