MyCommand

[davor.TCS]

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]

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]

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]

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.