search

vieten / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Changing Encoding always recognised on the second run of the dump file #998

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.changing encoding to latin5 instead of utf8 before running a sql dump
2.it stays utf8 in the first run, I drop the db and re-run
3.than it recognises the latin5 encoding.

What is the expected output? What do you see instead?
Expected output is latin5 encoding but we see utf8 instead at first dump.

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?
9.8.1 Sequel and mysql 5.1.54 OSX Snow Leopard MAcbook PRO latest i7 model.

Please provide any additional information below.

Original issue reported on code.google.com by murathan...@gmail.com on 8 Mar 2011 at 3:42

GoogleCodeExporter commented 9 years ago 
Hi there,

How are you running the SQL dump - via File -> Import, or via the query editor? 
 Does the SQL dump include any "SET NAMES" type encoding commands?

Original comment by rowanb@gmail.com on 8 Mar 2011 at 4:11

GoogleCodeExporter commented 9 years ago 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Yes I use Querry window. I change utf8 above to latin5 but it works on second 
run. I have to drop the first dump and re-run.

Original comment by murathan...@gmail.com on 8 Mar 2011 at 4:23

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 12 Mar 2011 at 3:33

GoogleCodeExporter commented 9 years ago

Original comment by mattlangtree on 15 Mar 2012 at 10:48

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 1 Apr 2012 at 4:42