Devart Forums

my code:
procedure TForm1.Button2Click(Sender: TObject);
begin
MyQuery1.Close;

MyQuery1.SQL.Text :=
'drop table if exists `test`;' +
'CREATE TABLE `test` (' +
'`ID` int(11) unsigned NOT NULL AUTO_INCREMENT,' +
'`錦` char(50) DEFAULT NULL,' +
'PRIMARY KEY (`ID`),' +
'UNIQUE KEY `ID` (`ID`)' +
') ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;' +
'insert into `test` (`錦`) values (''錦'')';
MyQuery1.Execute;

MyQuery1.SQL.Text := 'select * from `test`';
MyQuery1.Open;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
if MyQuery1.Active then
MyQuery1.Refresh
else
MyQuery1.Open;
end;


when cinnection option use unicode is true , fields valus char "" -> "?"

when cinnection option use unicode is false, field name char "" -> "?"

Please specify the exact version of your IDE.

Dimon wrote:Please specify the exact version of your IDE.

delphi 2010
mydac 5.90.051

This problem is connected with the specificity of MySQL server, but not with MyDAC.
It seems that MySQL doesn't allow to create fields with such symbol.

Dimon wrote:This problem is connected with the specificity of MySQL server, but not with MyDAC.
It seems that MySQL doesn't allow to create fields with such symbol.

thanks.