Zeoslib Portal

Posted: **17.03.2014, 12:21**

I use ZEOSDBO-7.1.3a-stable. I have a table with VARCHAR(5) fields in MySQL 5.5.35-database, but in Delphi XE5 all these fields are defined as TBytesField. So, what's wrong??? Why not just TStringField??? In ZEOSDBO-7.0.4-stable everything was good...
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

Table is

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;

Record is

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 '

Posted: **18.03.2014, 13:52**

Please, help!

Zeoslib Portal

Problem with VARCHAR field

Problem with VARCHAR field

Re: Problem with VARCHAR field