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 20:31:52 GMT
yes, with varchar it works fine


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

-- 
Mit freundlichen Grüßen 
Vatter
 
Network Inventory Software
Sun Microsystems Principal Partner

www.network-inventory.de
Tel. 030-79782510
E-Mail thomas.vatter@network-inventory.de


Mime
View raw message