MyCommand

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
davor.TCS
Posts: 18
Joined: Thu 05 Apr 2012 22:10

MyCommand

Post by davor.TCS » Fri 29 Nov 2019 14:20

I have a problem with MyDAC version 10.0.1 and MyCommand. It does not process corectly UTF8 strings (chars like č, ć, ž, đ). In my connection I set UseUnicode to true.

ViktorV
Devart Team
Posts: 2875
Joined: Wed 30 Jul 2014 07:16

Re: MyCommand

Post by ViktorV » Fri 29 Nov 2019 14:22

In order for us to be able to give you a detailed answer, we need a sample demonstrating the behavior you mentioned. Therefore, please, compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html

davor.TCS
Posts: 18
Joined: Thu 05 Apr 2012 22:10

Re: MyCommand

Post by davor.TCS » Sat 18 Apr 2020 16:30

Here is sample, problem still exists. When qry runned with Command, in field Descr are stored ????? as data.

Code: Select all

USE mydb;

DROP TABLE IF EXISTS `mytable`;

CREATE TABLE `mytable` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `Field1` tinyint(3) DEFAULT NULL,
  `Field2` tinyint(3) DEFAULT NULL,
  `Field3` tinyint(3) unsigned DEFAULT NULL,
  `AppID` tinyint(3) DEFAULT NULL,
  `Report` mediumblob,
  `Descr` varchar(80) DEFAULT NULL,
  `Operater` varchar(20) DEFAULT NULL,
  `LastChange` datetime DEFAULT NULL,
  `NoChange` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `mytable`(`ID`,`Field1`,`Field2`,`Field3`,`AppID`,`Report`,`Descr`,`Operater`,`LastChange`,`NoChange`) values (31,0,0,3,0,NULL,'Листа корисника у терминалу','admin',NULL,0);
INSERT INTO `mytable`(`ID`,`Field1`,`Field2`,`Field3`,`AppID`,`Report`,`Descr`,`Operater`,`LastChange`,`NoChange`) values (32,0,0,3,1,NULL,'Слике догађаја и запослених','admin',NULL,0);
INSERT INTO `mytable`(`ID`,`Field1`,`Field2`,`Field3`,`AppID`,`Report`,`Descr`,`Operater`,`LastChange`,`NoChange`) values (33,0,0,3,3,NULL,'Детаљни извештај са временима свих улазака/излазака','admin',NULL,1);
INSERT INTO `mytable`(`ID`,`Field1`,`Field2`,`Field3`,`AppID`,`Report`,`Descr`,`Operater`,`LastChange`,`NoChange`) values (34,1,1,3,3,NULL,'Детаљни извештај са почетком-крајем смене и ранијим одласцима','admin',NULL,1);
INSERT INTO `mytable`(`ID`,`Field1`,`Field2`,`Field3`,`AppID`,`Report`,`Descr`,`Operater`,`LastChange`,`NoChange`) values (35,2,2,3,3,NULL,'Стандардни извештај са временима по данима обрачунатих догађаја','admin',NULL,1);

UPDATE `mytable` SET LastChange = NOW();

ViktorV
Devart Team
Posts: 2875
Joined: Wed 30 Jul 2014 07:16

Re: MyCommand

Post by ViktorV » Tue 21 Apr 2020 09:58

Unfortunately, we haven't been able to reproduce the issue neither in MyDAC 10.1.3 nor in MyDAC 10.0.1. When the option TMyConnection.Options.UseUnicode is enabled, all read / write operations are performed correctly.
Please create and send us using the contact form https://devart.com/company/contactform.html a complete sample demonstrating the incorrect behavior, along with scripts for creating and populating database objects.

Post Reply