How to ignore case for string comparison in DB2 (CurrentCultureIgnoreCase not working)

Question

The CurrentCultureIgnoreCase operative worked fine on the SQL Server instance. It however isn't working on the DB2 instance I have of the same application.

I have tried the following ones:

Working (although concerned about performance hit):

s.POSTCODE.Trim().ToLower() == q.Trim().ToLower();

Not Working:

s.POSTCODE.Trim().Equals(q, StringComparison.OrdinalIgnoreCase);

Not Working:

s.POSTCODE.Trim().Equals(q, StringComparison.CurrentCultureIgnoreCase);

Any suggestions?

Thanks.

In the first example you trim **q** too. StringComparison.*IgnoreCase does not perform any trimming. — Adriano Repetti, May 23 '12 at 10:59
I hadn't noticed that! I guess that works too, as well as my answer! — CallumVass, May 23 '12 at 11:13
you should take a look at this http://msdn.microsoft.com/en-us/library/hyxc48dt hope it will help you out. — Zaksh, May 23 '12 at 11:19

CallumVass · Answer 1 · 2012-05-23T11:08:06.890

0

Use string.Equals()

So: string.Equals(s.POSTCODE.Trim(), q.Trim(), StringComparison.CurrentCultureIgnoreCase);

Hope it helps!

edited May 23 '12 at 11:08

answered May 23 '12 at 11:02

CallumVass

10,978
26
79
148

Get the following error: Incorrect number of arguments supplied for call to method 'Boolean Equals(System.String, System.String, System.StringComparison)' – stats101 May 23 '12 at 11:54
Using: var res = from s in db.ADDRESS where string.Equals(s.POSTCODE.Trim(), q.Trim(), StringComparison.CurrentCultureIgnoreCase) select s; – stats101 May 23 '12 at 11:54
Ahh you're using it like that, I dont believe that is possible, maybe try Linq? `var res = dbContext.Address.Where(x=> string.Equals(x.POSTCODE.Trim(), q.Trim(), StringComparison.CurrentCultureIgnoreCase));` – CallumVass May 23 '12 at 12:12
hmm.. maybe see here: http://stackoverflow.com/questions/5080727/string-equals-not-working-as-intended But I just tried the code I posted in my comment and it worked fine :S – CallumVass May 23 '12 at 13:06
I on the main post that all the comparison attempts are working fine on the SQL Server database, but not on the IBM DB2 database. Think it's a bug. :S – stats101 May 23 '12 at 13:44

score 0 · Accepted Answer · answered May 31 '12 at 12:28

0

For whatever reason, the only string comparison denomination that works on DB2 is:

s.POSTCODE.Trim().ToLower() == q.Trim().ToLower();

Have tried various alternate forms with no luck.

answered May 31 '12 at 12:28

stats101

1,787
7
31
49

How to ignore case for string comparison in DB2 (CurrentCultureIgnoreCase not working)

2 Answers2