Encoding problem - UTF8 - Polish letters

[Desseres]

Hey!

I tested dbForge for MySQL and I found one problem. Big problem for me. Editor record does not support the Polish character. Do you have a solution for this problem?





For example, this same data in MySQL Workbench



Database query

Code: Select all

CREATE TABLE test.dr_druzyna (
  dr_Id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  dr_Nazwa VARCHAR(255) NOT NULL,
  dr_Skrot VARCHAR(10) NOT NULL,
  dr_Miasto INT(11) NOT NULL,
  dr_Wojewodztwo INT(11) NOT NULL,
  dr_NIP VARCHAR(20) DEFAULT NULL,
  dr_REGON VARCHAR(20) DEFAULT NULL,
  dr_KRS VARCHAR(20) DEFAULT NULL,
  dr_Adres VARCHAR(255) DEFAULT NULL,
  dr_Email VARCHAR(50) DEFAULT NULL,
  dr_Telefon VARCHAR(50) DEFAULT NULL,
  dr_WWW VARCHAR(50) DEFAULT NULL,
  dr_Twitter VARCHAR(255) DEFAULT NULL,
  dr_Facebok VARCHAR(255) DEFAULT NULL,
  dr_Youtube VARCHAR(255) DEFAULT NULL,
  dr_Instagram VARCHAR(255) DEFAULT NULL,
  dr_LigaData DATE NOT NULL,
  created_at TIMESTAMP NULL DEFAULT NULL,
  updated_at TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (dr_Id)
)
ENGINE = INNODB
AUTO_INCREMENT = 17
AVG_ROW_LENGTH = 1024
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

I get the same error when trying to write data to the database.

Code: Select all

INSERT INTO dr_druzyna (`dr_Nazwa`, `dr_Skrot`, `dr_Miasto`, `dr_Wojewodztwo`, `dr_LigaData`) VALUES ('Angels Toruń', 'AT', 1, 1, '2016-01-01');

[Desseres]

I found a solution in another thread. viewtopic.php?f=23&t=30307&p=103973&hil ... ng#p103973

Please try specifying the UTF8 encoding on the 'Advanced' tab of the 'Database Connection Properties' dialog box (right-click the connection in Database Explorer of dbForge Studio for MySQL and select 'Modify Connection' from the popup menu).

[alexa]

We are glad to know you have found the solution for the issue and will be happy to help you in case you experience any difficulties with the product in future.