CODEWITHSUNDEEP
db2collation
nerko
nerko

Reputation: 3

DB2 accent insensitive queries

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

The version of my DB2 database is v6r1m0.

thanks

Upvotes: 0

Views: 1464

Answers (1)

AngocA
AngocA

Reputation: 7693

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!

Upvotes: 1

Related Questions