DB2 accent insensitive queries

Question

is there any way of getting accent insensitive results in a select query in DB2?

The version of my DB2 database is v6r1m0.

thanks

See here for an example that will work in DB2 for LUW https://stackoverflow.com/questions/48100215/remove-accents-db2/52304253#52304253 . Not sure if it would work in DB2 for i. — Paul Vernon, Sep 12 '18 at 22:31

score 1 · Accepted Answer · edited Nov 10 '15 at 13:11

1

You could change the case of the column and the value you are looking for.

For example

Select upper(lastname)
From myTable
where upper(name) = upper('John')

You can use:

However, I am not sure if these functions are available in your very old DB2 version. Plan to upgrade!

edited Nov 10 '15 at 13:11

DJo

answered Jul 19 '13 at 12:14

AngocA

1 Answers1