Pb with MyDAC5 + Dephi 2007 Pro (GBK)

[vga]

My DB:
CREATE DATABASE `test`
My Table:
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`Name` char(50) default NULL,
`Date` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;


My Code:
procedure TForm1.FormCreate(Sender: TObject);
begin
MyConnection1.Connected := true;
MyTable1.Active := true;
end;

procedure TForm1.MyConnection1AfterDisconnect(Sender: TObject);
begin
MyQuery1.SQL.Text := 'set names gbk';
MyQuery1.Execute;
end;

when I enter GBK chars Error occured, what should I do?

[vga]

delete the followings code:

procedure TForm1.MyConnection1AfterDisconnect(Sender: TObject);
begin
MyQuery1.SQL.Text := 'set names gbk';
MyQuery1.Execute;
end;

It will be fine!


How to make the DBExpress Work with GBK (MySQL Database 5 )?

[Antaeus]

To set a character set for the current connection, you should use the Charset options of TMyConnection.

> How to make the DBExpress Work with GBK (MySQL Database 5 )?
If you are using DbxMda, the extended driver option Charset will be useful for you. See description of the extended driver options in the ReadMe.html of DbxMda.

[vga]

Thank you, use the Charset options of TMyConnection. It's OK

thanks a lot.