search

vieten / sequel-pro

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

Permission error when using UTF-8 Uncode via Latin 1 #1207

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
On some of my tables i get an error when selecting the table if I have set 
"View User Encoding" to "UTF-8 Uncode via Latin 1"
The encoding on the table is Unicode Utf-8 and collation is utf8_general_ci and 
I have not set any specific encodings on any collums.

It all works fine if i set "View User Encoding" to "UTF-8 Unicode (utf8)" exept 
my å, ä and ö are all messed up.

This is the error:

Permission Denied

The creation syntax could not be retrieved due to a permissions error.

Please check your user permissions with an administrator.

This table produces an error:

CREATE TABLE `personal` (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `a_id_sec` varchar(32) NOT NULL DEFAULT '',
  `a_fornamn` varchar(20) NOT NULL DEFAULT '',
  `a_efternamn` varchar(40) NOT NULL DEFAULT '',
  `a_adress` varchar(40) NOT NULL DEFAULT '',
  `a_postnummer` varchar(10) NOT NULL DEFAULT '',
  `a_ort` varchar(30) NOT NULL DEFAULT '',
  `a_email` varchar(40) NOT NULL DEFAULT '',
  `a_mobiltelefon` varchar(15) NOT NULL DEFAULT '',
  `a_telefon` varchar(15) NOT NULL DEFAULT '',
  `a_kon` enum('Man','Kvinna') NOT NULL DEFAULT 'Man',
  `a_korkort` set('B','C','D','BE','CE','DE','ADR','TRUCK') DEFAULT NULL,
  `a_alder` int(11) NOT NULL DEFAULT '0',
  `a_truck` enum('J','N') NOT NULL DEFAULT 'N',
  `a_egenbil` enum('J','N') NOT NULL DEFAULT 'N',
  `a_villarbeta` enum('0-5','6-10','11-15','16-20','21-25','26-30','31-','Projekt') NOT NULL DEFAULT '0-5',
  `a_hittat` enum('-----','Tidning','Internet','Radio','TV','Vän','Flygblad','Event','Hemsida','Uppringd','Övrigt') NOT NULL DEFAULT 'Tidning',
  `a_hittatspec` varchar(80) NOT NULL DEFAULT '',
  `a_kommentar` text NOT NULL,
  `a_regdatum` date DEFAULT NULL,
  `a_regid` int(11) DEFAULT NULL,
  `a_anstdatum` date DEFAULT NULL,
  `a_personnummer` varchar(13) NOT NULL DEFAULT '',
  `a_bank` varchar(40) NOT NULL DEFAULT '',
  `a_bankadress` varchar(40) NOT NULL DEFAULT '',
  `a_bankpostnummer` varchar(10) NOT NULL DEFAULT '',
  `a_bankort` varchar(30) NOT NULL DEFAULT '',
  `a_clearingnummer` varchar(10) NOT NULL DEFAULT '',
  `a_kontonummer` varchar(30) NOT NULL DEFAULT '',
  `a_timlon` int(11) NOT NULL DEFAULT '0',
  `a_semesterers` int(11) NOT NULL DEFAULT '0',
  `a_skattesats` int(11) NOT NULL DEFAULT '3000',
  `a_sarskild_loneskatt` enum('J','N') NOT NULL DEFAULT 'N',
  `a_ungdomsrabatt` enum('J','N') NOT NULL DEFAULT 'N',
  `a_losenord` varchar(20) NOT NULL DEFAULT '',
  `a_kontor` varchar(40) DEFAULT NULL,
  `a_regav` varchar(40) DEFAULT NULL,
  `a_losenord2` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1147 DEFAULT CHARSET=utf8;

What is the expected output? What do you see instead?

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?

Please provide any additional information below.

Original issue reported on code.google.com by run...@gmail.com on 10 Oct 2011 at 7:12

GoogleCodeExporter commented 9 years ago 
It posted before I got to finish.....

Sequel pro: 0.9.9.1
SQL version: 5.1.39-community

Original comment by run...@gmail.com on 10 Oct 2011 at 7:16

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 24 Oct 2013 at 5:09