Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

search special characters with english alphabets

 
Nikhil Menon
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a situation where I need to search data in DB2 under this condition:

If a person wish to search on a name : Mathew the search results should also return the values where the name is having the latin-1 Supplement characters in that name such as for the character 'a' it should also search for 'a' with a tilde above it or 'a' with a ring above it etc. Has anybody come across such requirements? does some one has any thoughts?
I thought I will have to use Unicode based search on the DB2.. . Or to resolve the various combinations for search in Java itself by creating the Composite Unicode for the Latin-1 Supplement using the Unicode of 'a'. Any ideas? or Any api available for this translation. Please share your thoughts
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic