This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
June 21, 2009 12:13pm
Subscribe [2]#1 / Jun 21, 2009 12:13pm
Hi guys,
I noticed that when you use the ee search it seems case sensitive.
You can try it yourself on http://www.packed.be.
How can i fix this so its not case sensitive. The collation of the database is utf8_bin and utf8_general_ci.
Thanks in advance,
#2 / Jun 21, 2009 6:46pm
Can you confirm that all of your tables are set to case insensitive?
-greg
#3 / Jun 22, 2009 5:05am
Hi Greg,
This is the create table commando of the exp_weblog_entries.
CREATE TABLE `exp_weblog_data` (
`entry_id` int(10) unsigned NOT NULL,
`site_id` int(4) unsigned NOT NULL default '1',
`weblog_id` int(4) unsigned NOT NULL,
`field_id_1` text collate utf8_bin NOT NULL,
`field_ft_1` tinytext collate utf8_bin,
`field_id_2` text collate utf8_bin NOT NULL,
`field_ft_2` tinytext collate utf8_bin,
`field_id_3` text collate utf8_bin NOT NULL,
`field_ft_3` tinytext collate utf8_bin,
`field_id_4` text collate utf8_bin NOT NULL,
`field_ft_4` tinytext collate utf8_bin,
`field_id_5` text collate utf8_bin NOT NULL,
`field_ft_5` tinytext collate utf8_bin,
`field_id_6` text collate utf8_bin NOT NULL,
`field_ft_6` tinytext collate utf8_bin,
`field_id_7` text collate utf8_bin NOT NULL,
`field_ft_7` tinytext collate utf8_bin,
`field_id_8` text collate utf8_bin NOT NULL,
`field_ft_8` tinytext collate utf8_bin,
`field_id_9` text collate utf8_bin NOT NULL,
`field_ft_9` tinytext collate utf8_bin,
`field_id_10` text collate utf8_bin NOT NULL,
`field_ft_10` tinytext collate utf8_bin,
`field_id_11` text collate utf8_bin NOT NULL,
`field_ft_11` tinytext collate utf8_bin,
`field_id_12` text collate utf8_bin NOT NULL,
`field_ft_12` tinytext collate utf8_bin,
`field_id_13` text collate utf8_bin NOT NULL,
`field_ft_13` tinytext collate utf8_bin,
`field_id_15` text collate utf8_bin NOT NULL,
`field_ft_15` tinytext collate utf8_bin,
`field_id_16` text collate utf8_bin NOT NULL,
`field_ft_16` tinytext collate utf8_bin,
`field_id_17` text collate utf8_bin NOT NULL,
`field_ft_17` tinytext collate utf8_bin,
`field_id_18` text collate utf8_bin NOT NULL,
`field_ft_18` tinytext collate utf8_bin,
`field_id_19` text collate utf8_bin NOT NULL,
`field_ft_19` tinytext collate utf8_bin,
`field_id_20` text collate utf8_bin NOT NULL,
`field_ft_20` tinytext collate utf8_bin,
`field_id_21` text collate utf8_bin NOT NULL,
`field_ft_21` tinytext collate utf8_bin,
`field_id_22` text collate utf8_bin NOT NULL,
`field_ft_22` tinytext collate utf8_bin,
`field_id_23` text collate utf8_bin NOT NULL,
`field_ft_23` tinytext collate utf8_bin,
`field_id_24` text collate utf8_bin NOT NULL,
`field_ft_24` tinytext collate utf8_bin,
`field_id_25` text collate utf8_bin NOT NULL,
`field_ft_25` tinytext collate utf8_bin,
`field_id_26` text collate utf8_bin NOT NULL,
`field_ft_26` tinytext collate utf8_bin,
`field_id_27` text collate utf8_bin NOT NULL,
`field_ft_27` tinytext collate utf8_bin,
`field_id_28` text collate utf8_bin NOT NULL,
`field_ft_28` tinytext collate utf8_bin,
`field_id_29` text collate utf8_bin NOT NULL,
`field_ft_29` tinytext collate utf8_bin,
`field_id_30` text collate utf8_bin NOT NULL,
`field_ft_30` tinytext collate utf8_bin,
`field_id_31` text collate utf8_bin NOT NULL,
`field_ft_31` tinytext collate utf8_bin,
`field_id_32` text collate utf8_bin NOT NULL,
`field_ft_32` tinytext collate utf8_bin,
`field_id_33` text collate utf8_bin NOT NULL,
`field_ft_33` tinytext collate utf8_bin,
`field_id_34` text collate utf8_bin NOT NULL,
`field_ft_34` tinytext collate utf8_bin,
`field_id_35` text collate utf8_bin NOT NULL,
`field_ft_35` tinytext collate utf8_bin,
`field_id_36` text collate utf8_bin NOT NULL,
`field_ft_36` tinytext collate utf8_bin,
`field_id_38` text collate utf8_bin NOT NULL,
`field_ft_38` tinytext collate utf8_bin,
`field_id_39` text collate utf8_bin NOT NULL,
`field_ft_39` tinytext collate utf8_bin,
`field_id_40` text collate utf8_bin NOT NULL,
`field_ft_40` tinytext collate utf8_bin,
`field_id_41` text collate utf8_bin NOT NULL,
`field_ft_41` tinytext collate utf8_bin,
`field_id_42` text collate utf8_bin NOT NULL,
`field_ft_42` tinytext collate utf8_bin,
`field_id_43` text collate utf8_bin NOT NULL,
`field_ft_43` tinytext collate utf8_bin,
`field_id_44` text collate utf8_bin NOT NULL,
`field_ft_44` tinytext collate utf8_bin,
`field_id_45` text collate utf8_bin NOT NULL,
`field_ft_45` tinytext collate utf8_bin,
`field_id_46` text collate utf8_bin NOT NULL,
`field_ft_46` tinytext collate utf8_bin,
`field_id_47` text collate utf8_bin NOT NULL,
`field_ft_47` tinytext collate utf8_bin,
`field_id_48` text collate utf8_bin NOT NULL,
`field_ft_48` tinytext collate utf8_bin,
`field_id_49` text collate utf8_bin NOT NULL,
`field_ft_49` tinytext collate utf8_bin,
`field_id_50` text collate utf8_bin NOT NULL,
`field_ft_50` tinytext collate utf8_bin,
`field_id_51` text collate utf8_bin NOT NULL,
`field_ft_51` tinytext collate utf8_bin,
`field_id_55` text collate utf8_bin NOT NULL,
`field_ft_55` tinytext collate utf8_bin,
`field_id_56` text collate utf8_bin NOT NULL,
`field_ft_56` tinytext collate utf8_bin,
`field_id_61` text collate utf8_bin NOT NULL,
`field_ft_61` tinytext collate utf8_bin,
`field_id_62` text collate utf8_bin NOT NULL,
`field_ft_62` tinytext collate utf8_bin,
`field_id_64` text collate utf8_bin NOT NULL,
`field_ft_64` tinytext collate utf8_bin,
`field_id_65` text collate utf8_bin NOT NULL,
`field_ft_65` tinytext collate utf8_bin,
KEY `entry_id` (`entry_id`),
KEY `weblog_id` (`weblog_id`),
KEY `site_id` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin#4 / Jun 22, 2009 5:20pm
utf8_bin is a case sensitive collation, so you are actually seeing expected behavior here. You should probably use utf8_general_ci. Make a backup, then try to change the collation of (at least) exp_weblog_titles and exp_weblog_data.