Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Tue, Jul 20 2010 4:56 PM	Permanent Link
Charalampos Michael	Hello, The below gives an index scan: medicine like '%mymedicine%' The below gives a row scan: lower(medicine) like '%mymedicine%' I just want to do it case insensitive. Any ideas ? -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr
Wed, Jul 21 2010 3:44 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Charalampos > The below gives an index scan: > medicine like '%mymedicine%' > > The below gives a row scan: > lower(medicine) like '%mymedicine%' > >I just want to do it case insensitive. > >Any ideas ? Two things 1) you need a case insenisitive index and if the column itself isn't case insensitive 2) you need to specify the collation eg medicine collate ansi_ci like '%myedicine%' [Team Elevate]
Wed, Jul 21 2010 4:51 AM	Permanent Link
Charalampos Michael	Dear Roy, > 2) you need to specify the collation eg > > medicine collate ansi_ci like '%myedicine%' That was it! With EDB i need to specify the collation. Thank you -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr
Wed, Jul 21 2010 5:35 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Michael, Also, see here for more information: http://www.elevatesoft.com/articles?action=view&category=edb&article=collations_comparisons -- Tim Young Elevate Software www.elevatesoft.com
Wed, Jul 21 2010 8:01 PM	Permanent Link
Charalampos Michael	Dear Tim, > Also, see here for more information: > > http://www.elevatesoft.com/articles?action=view&category=edb&article=collations_comparisons Thank you! -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr