Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Case Insensitive LIKE index scan ... |
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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |