I have a TUniQuery that I want to use in SmartFetch mode.
'select id, name from types' --> works ok
'select id, NamE from types' --> raises ESmartFetchError: 'Fields of received result set do not correspond to fields of source dataset.'
Is there any option to turn off the case sensitivity?
My setup ix XE7, UniDAC 6.0.2, MySQL 5.5.41
The table is created like this:
Code: Select all
CREATE TABLE `types` (
`id` INT(10) NOT NULL DEFAULT '0',
`name` VARCHAR(50) NOT NULL,
`price` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;