Problem with VARCHAR field

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Post Reply
GlamCity
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 17.03.2014, 12:07

Problem with VARCHAR field

Post by GlamCity »

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 '
GlamCity
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 17.03.2014, 12:07

Re: Problem with VARCHAR field

Post by GlamCity »

Please, help!
Post Reply