SmartFetch and case sensitivity
Posted: Thu 28 May 2015 14:14
Hello,
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:
Thank you.
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;