db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas.vat...@network-inventory.de>
Subject Re: like '%something'
Date Tue, 28 Feb 2006 12:21:54 GMT
I understand, I'll change the code. the code had worked with other dbms, 
but no problem to change it

tom

Knut Anders Hatlen wrote:

>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
>
>  
>


Mime
View raw message