Hi,

Suppose i have following two tables with sample data as shown below.

Table - A

AId     name
I1     v1
I2     v2

Table - B

BId     name
1       V1
2       v2

If i make inner join on both the tables using mysql on name column, it will return me both rows. It means it is behaving case insensitive.

AId     BId
I1       1
I2       2

But when i used same table using BrightHouse engine it is behaving case sensitive and returning only single row.

AId     BId
I2       2

How can i make Infobright case insensitive?

Hi arunsinghal,

You can take a look at the post here.

Hi,

Adding to what Kim already wrote in the other thread, you can specify case insensitive collation when creating a table, e.g.

You can always examine collations of existing tables by invoking

Hope it helps,

Piotr

Hi,

I tried collation option with infobright version 3.3.1 and 3.3.2 but it does not work for me. Here is the create table query

CREATE TABLE `dim_test` (
  `id` INT(11) NOT NULL,
  `value` VARCHAR(20) NOT NULL COLLATE latin1_general_ci
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8;

I also tried this with

CREATE TABLE `dim_test` (
  `id` INT(11) NOT NULL,
  `value` VARCHAR(20) NOT NULL COLLATE utf8_general_ci
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8;

Do these versions support collation or not or am i doing something wrong?

Hi !

See http://www.infobright.org/downloads/pdfs/ICE_3.3.2_Beta_Release_Notes.pdf . Probably you should set the parameter UseCharset = 1 in brighthouse.ini