By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

accent insensitive diacritic insensitive data retrieval

P: n/a
Hi,

Is there any option / feature in DB2 database where one can retrieve
data from the database by treating the accented / diacritic characters
equivalent to their English characters. For example I would like ""
is treated equivalent to "a" or "" is treated equivalent to "e" so
that the SELECT query can retreive data irrespective if it has accented
or non-accented characters.

This is required because we have French and German names in our
database but the support personnel who usually searches the database
has an English keyboard as a result entering the accented characters in
the application is difficult.

Please let me know how could I resolve thhe problem.

Thanks & Regards,
Vinay

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Vinay,
Add a new column in the table called S_name. create a UDF to remove all
the accent from the name column and save the result in upper case in
the S_name column.
For example:
If the valumn in name column is '', then the value in
S_name is 'EEEAAA'.

In your query, you use column S_name as search column and display
column name. (User enter no-accent string for searching, you conver
string into Upper case first.)

HTH,

Bill

vin...@rocketmail.com wrote:
Hi,

Is there any option / feature in DB2 database where one can retrieve
data from the database by treating the accented / diacritic characters equivalent to their English characters. For example I would like ""
is treated equivalent to "a" or "" is treated equivalent to "e" so
that the SELECT query can retreive data irrespective if it has accented or non-accented characters.

This is required because we have French and German names in our
database but the support personnel who usually searches the database
has an English keyboard as a result entering the accented characters in the application is difficult.

Please let me know how could I resolve thhe problem.

Thanks & Regards,
Vinay


Nov 12 '05 #2

P: n/a
Dear Bill,

Thanks for the response, I had already found similar solution in the
db2 user group. But this solution will increase the tablespace
unnecessarily.

Actually I was looking at some database configuration parameter which
could allow diacritic insensitive search (something similar to the one
available in Oracle).

Thanks & Regards,
Vinay

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.