TConnection is defined:
Code: Select all
object ZCSettings: TZConnection
ControlsCodePage = cCP_UTF16
ClientCodepage = 'utf8'
Catalog = ''
Properties.Strings = (
'controls_cp=CP_UTF16'
'codepage=utf8')
Connected = True
HostName = '10.4.10.1'
Port = 3306
Database = 'settings'
User = 'root'
Password = 'root'
Protocol = 'mysql-5'
Left = 48
Top = 64
end
Code: Select all
CREATE TABLE `aaxx` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id000` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`id001` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`id002` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`id003` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`id004` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`dt` datetime DEFAULT NULL,
`comment` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Code: Select all
'90', 'AAXX', '09181', '28502', '42997', '80701', '10195', '20151', '30028', '40126', '53007', NULL, NULL, '8805/', '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '91003', '91105', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-08-09 22:21:02', 'Meteo message '