Hello
I have “problem” with LIKE operator.
I have two database systems - normal MySQL (MyISAM) and Infobright (Infobright). These systems are the same encoding: latin2_general_ci.
On MySQL I can use LIKE with small letter, but on Infobright I will have to use UPPER, because I don’t know how letters is in table.
Example:
Simple query on MySQL and Infobright get the same data:
select id, name
from table
where id = 1
MyISAM-> 1, Slawek
Infobright-> 1, Slawek
If I want to use LIKE operator
select id, name
from table
where name like '%slawek%'
MyISAM-> 1, Slawek
Infobright-> NULL
On Infobright I will have to use
UPPER(name) like UPPER('%slawek%')
.
Why Infobright cannot interpret this query? Maybe I need configure it?
This is a problem, because we have problems with integration software. Older code and scripts do not work well.
Thanks!
Cheers,
Slawek
