Thomas Vatter <[EMAIL PROTECTED]> writes:
> this is working
> select col from table where lower(col) like '%something%'
> this is not
> select col from table where lower(col) like '%something'
> try it with value in database = XXXsomething
> seems like derby auto generates trailing blanks
You should use VARCHAR instead of CHAR. CHAR is fixed length (with
trailing spaces) and VARCHAR is variable length.
ij> create table t (text varchar(20));
0 rows inserted/updated/deleted
ij> insert into t values ('something'), ('something2');
2 rows inserted/updated/deleted
ij> select * from t where text like '%something';
TEXT
--------------------
something
1 row selected
ij> create table t2 (text char(20));
0 rows inserted/updated/deleted
ij> insert into t2 values ('something'), ('something2');
2 rows inserted/updated/deleted
ij> select * from t2 where text like '%something';
TEXT
--------------------
0 rows selected
--
Knut Anders
