TMyDump and Unicode

[cybsistemas]

Cannot make backup with TMydump of a field "text" with unicode options.

Try mydump1.restore with that file
http://www.carlosbuira.com.ar/kines.Sql

MyDAC version: 5.90.0.59 - Delphi 2010

File with Mydump no unicode
http://www.carlosbuira.com.ar/nounicode.sql

[Dimon]

I can not reproduce the problem.
When does the problem appear - on backing up or on restoring data?
Also, please, specify the code page used on your machine.

[cybsistemas]

Windows 7 Spanish
MySQL 5.5
utf8_unicode_ci

When execute Dump.RestoreFromFile('kines.sql') not generate messages of error but the field "text" are not recognizable for the dbmemo.

execute Dump.RestoreFromFile('kines.sql') in the database test and check what I say

[Dimon]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build. But this fix is connected with backing up data, not with restoring.
To solve the problem set TMyConnection.Options.Charset to the utf8 value and TMyConnection.Options.UseUnicode to False before backing up data.

[cybsistemas]

Thanks. It is what I am doing for the moment

[cybsistemas]

Version 5.0.90.60
Improved, but continue problem.
Example in backup ó Write ó

[Dimon]

Please send me a script to create and fill a table to dmitryg*devart*com to demonstrate the problem.

[cybsistemas]

Myconnection1.options.charset := utf8;
Myconnection1.options.useunicode := True;
execute MyDump1.BackupToFile('file.Sql');

-- MyDAC version: 5.90.0.60
-- MySQL server version: 5.1.49-community
-- MySQL client version: 4.1.3 Direct
-- Script date 16/08/2010 13:36
-- ----------------------------------------------------------------------
-- Server: localhost
-- Database: kines

/*!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_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
--
-- Table structure for table tratamiento
--
DROP TABLE IF EXISTS tratamiento;
CREATE TABLE `tratamiento` (
`Id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Ficha` text,
PRIMARY KEY (`Id`),
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table tratamiento
--
LOCK TABLES tratamiento WRITE;
INSERT INTO tratamiento VALUES
(1,'2do. TK. 18/03/05.\r\nExamen: región der\r\n');(in memofield say región)
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[Dimon]

To solve the problem try to set TMyConnection.Options.UseUnicode to False before backing up data.

[cybsistemas]

Thanks. It is what I am doing for the moment

[ioannisa]

I am using version 7.2.7 of MyDAC and I am having the same problem.

I remember this problem that was solved with version 6.00.0.5. I had this and 6.00.0.5 solved it. But now it appears again.

When backing up with this version I get text like this
Αξεσουάρ (Τσάντες, Ζώνες, Καπέλα

I have to rollback to version 6 to backup normally under unicode.
Please advice!

[AndreyZ]

I have answered you at http://forums.devart.com/viewtopic.php?f=7&t=24413