db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: like '%something'
Date Tue, 28 Feb 2006 11:08:05 GMT
Thomas Vatter <thomas.vatter@network-inventory.de> 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

Mime
View raw message